Skip to Content
0
Former Member
Jun 27, 2008 at 03:01 AM

Weird excel file

9 Views

So I need to transfer the contents of one file into a table in the database. I first am required to save the file to a tab-delimited file. I did but then I notice that the amounts field in the excel file has amounts 1004.90

but in the text file it is "1004.90" and I noticed that if the amount is less than 1000. the amount field in the text file is without the "". but if it's more that 1000 it has "". I need to fix this in order to correctly transfer it to a table with currency as the data element. Any one knows how? Or is there any way to check if there is a "" in the file.? Any help would be appreciated.