Newbie Questions

Re: How do I trim a textfield string that contains numbers & characters to only use the numbers for a calculation?

supermanKelz — Fri, 22 Mar 2013 12:19:56 GMT

Ok part 2 time.

I've gotten the translate function to replace the parts of the string that I want, works great thanks! However, I'm having trouble figuring out the formula to perform the translate on a multiple selection list box.

Currently, I'm using this formula to keep track of ALL selected options in the list box: eval(eval(field1, 'concat(., ";")'), "..") This formula produces: Option-1; Option-2; Option-3. Now what I want to do is change the formula a bit so that it incorporates the TRANSLATE function to remove the text ("Option-" in this case), and sum the remaining numerical values (1, 2, 3) so that "6" is stored in a field (the field that holds the formula as default value).

Thanks for your help again!

JenniferLindsay:
Hi supermanKelz,

You can extract the text only by removing the numbers with the translate function:

translate(myUserInput,"0123456789", "")

And you can extract the numbers only by removing the letters and the dash with another call to the translate function:

translate(myUserInput, "ABCDEFGHIJKLMNOPQRSTUVWYXZabcdefghijklmnopqrstuvwyxz-","")

Re: How do I trim a textfield string that contains numbers & characters to only use the numbers for a calculation?

supermanKelz — Fri, 22 Mar 2013 00:08:22 GMT

Thanks so much, about to try it out now!

Re: How do I trim a textfield string that contains numbers & characters to only use the numbers for a calculation?

JenniferLindsay — Thu, 21 Mar 2013 22:34:24 GMT

Hi supermanKelz,

You can extract the text only by removing the numbers with the translate function:

translate(myUserInput,"0123456789", "")

And you can extract the numbers only by removing the letters and the dash with another call to the translate function:

translate(myUserInput, "ABCDEFGHIJKLMNOPQRSTUVWYXZabcdefghijklmnopqrstuvwyxz-","")

How do I trim a textfield string that contains numbers & characters to only use the numbers for a calculation?

supermanKelz — Thu, 21 Mar 2013 16:48:47 GMT

Hey all! This seemed like a newbie question so here it goes!

I am trying to take user input from a dropdown menu that has custom list items that have a TEXT display name and TEXT+NUMERIC value. For example, if a user selects "one time" from the dropdown, then Execution field holds the value "one-time50". I'm doing this because the selections need to hold a text value and a numeric value for calculation and summary display purposes.

Now, what I want to do with the execution field that has the value of "one-time50" is to have a text field display "one-time" and another field holds "50" that can be added to a formula for a calculation.

Any suggestions???

Thanks!