Hello…
Reading an exported .csv file from a web app of unknown origin into a data table then adding to queue. Any columns containing numeric values are importing with =“1234356” or just the quotes around the number. So far I’ve tried removing these artifacts by using replace, reading the csv as a text file then generating data table, split and substring…
replace works on some but not all cases after getting the transaction from the queue but I’d like to clean the data prior to adding to the queue
Any other suggestions?
Anil_G
rashmisingh2695
Parth_Sarnobat
Shravan_Pintu
Santhosh_Perumal