Hello everyone,
I need help with data type and the best way to fix it.
Let me explain the issue:
Pipe 1- I am accessing multiple files from a directory - CSV format. (hence every column is in string) - All price columns have dots and no comma.
Pipe 2- accessing database - format is perfect.
I need to compare the prices from both pipes. So I convert price of pipe 1 into 'double' using select tool. It works in 99% cases but fails in few.
I know using fixed decimal will fix my issue but I can't restrict my price and it has to be flexible.
I tried 'ToNumber' and that doesn't fix the issue.
If I convert all prices to string then PricePipe1 = PricePipe2 works but I need some basic numerical calculations as well.
I would appreciate any help in this regard.
Thanks!!!
