Hello all! I have a number serie thats formatted 1,788,50 how can i remove the first “,” from all number series ? So it only keeps the last “,” to seperate the decimal
You can use something like :
but what will happen if the number its 10,50 ?
It will remove that . Could you share some more sample numbers then?
its a dynamic number so everything from 1 - 100000, but it has to be 2 decimals if it has decimals. but when i run my current code it also splits the thousand with a “,” seperator :S
Test.xaml (7.1 KB)
hm how would the format be ? (string, (?=\d*,))
aha so the replace would just keep its form ?
The Replace will be regReplace.Replace(str, “”) (without the ,1 at the end)
hi @langsem, i know its late
but i had also done it
u can check the workflow too
firstcommaremover.zip (22.4 KB)
Hope it helps
ThaNKS THINK IT WORKED
Feeling great I can help you @langsem
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.