I have a .txt file that has a quantity column in it. When I attach the select tool to the input file, the quantity column comes in as V-String and has negative values. When I change the data type to Double, I lose the negative values and large values that have commas are lost; for example, 1,320 becomes 1. I reverted the field back to V-String and used Mutli-Field Formula to replace the comma in the number and changed the output type to Double, which looked to work but I still loose the negative values. I could just keep the data type as a V-String, but since it is a quantity column, I would like to have it as a number. Any suggestions?
