+10I am trying to extract the number before a decimal point but keep it as an integer. I have found posts about how to extract numbers, but they all convert them to text. I can’t seem to come up with the needed Regex formula, but I guess there might be another solution?
I would like to convert something like 2023.0 to just 2023.
Best answer by aak1
I just realized that when I upgraded this workflow from O365 to NAC it converted that variable to a decimal. I just created a new integer variable and replaced the old variable. I’m a little slow sometimes :(
It is working now.
+14Are you trying to do this in a workflow or on a form?
+14Try adding and configuring a “Apply a regular expression” action in your workflow with the following settings:
+10Thanks. It does strip out the “.0” but also only leaves the last number before the decimal point. So 2023.0 just becomes “3”.
+10I just realized that when I upgraded this workflow from O365 to NAC it converted that variable to a decimal. I just created a new integer variable and replaced the old variable. I’m a little slow sometimes :(
It is working now.
+14Sorry, I misread your original post.
Glad it is working now for you.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.