Hi @jmiskey
Try the below regex script to remove the non-numeric characters (except .) from the string.
var str = "<Input string>";
// Step 1: Remove any non-digit, non-comma, non-dot characters (like $)
str = str.replace(/[^\d.,]/g, '');
// Step 2: Remove commas
str = str.replace(/,/g, '');
// Step 3: Convert to number
var number = parseFloat(str);
gs.info("Extracted number: " + number);
Output:
Note: Modufy the script as required in the flow to set the output variable value
Hope this helps.
Regards,
Siva
why not add a number validation at variable level itself and ask user to enter only number?
Then no need to do any manipulation in flow
You can add this Variable Validation Regex to your variable
OR
If you want user to enter symbol as well while entering amount then you can use your OWN Regex and add it in variable validation Regex OR you can use onChange catalog client script and throw error if validation fails.
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur,
While I like your alternative solution (using a RegEx command), there is still one lingering issue with it that needs to be worked out. How do I convert the value into a number to be used in my Flow?
I am trying to create an IF statement that says "if the value is greater than 1000, then proceed...". However, if I choose the variable in an IF action in my Flow, since it is a Single Line Text variable, the only operators available to me are these text options:
Obviously, I need numeric operators like "greater than" and "less than". What is the easiest way to convert this entry to a numeric value in my flow so I can create my IF statement?
