Hi all, I´m trying to convert numbers storaged as V_Wstring in a csv file to a negative number.
The csv format storage the negative numbers with () (ex.: (238,456,791)
I tried two ways
If any additional data or screenshot is helpful please let me know and I´ll add it
Thanks a lot in advance!
Solved! Go to Solution.
Try ToNumber(Replace(Replace([Field],"(","-"),")",""))
Thanks a lot Alex!
It worked just fine 😊
Great news!