copy alphabetic characters only from a field

  • Profile Image
    Asked on May 23, 2016 at 11:32 AM


      I have checkbox as a food menu, the fields contain the name of the dish and the price. To make a list of dishes for cooks we want to have this copied to a text box but only the name of the dish (does not need the price).

    I thought if we did the [A-Z] option from {update/ calculate} conditional it would only copy over the letters and not numbers... I think it works this way in reverse, if you select [0-9] it will only copy numbers and drop the letters...


    Thanks for any advice

  • Profile Image
    Answered on May 23, 2016 at 01:01 PM


    While setting the character type to number will only pass numbers, setting it to [A-Z] will pass both letters and numbers. So, I'm not sure it is possible to split the entries from one field and get the letters without the digits. 

    What you could do is adding a regular Checkbox or Radio button, then go to the field properties and update the calculation values for the options.