Weird excel file

Former Member — Fri, 27 Jun 2008 03:01:11 GMT

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.

Re: Weird excel file

Former Member — Fri, 27 Jun 2008 03:27:34 GMT

hi,

any how before keeping the file data in to database table intern

you have to keep whole data in an internal table. while keeping the data into internal table just replace the " with space and condense.

this will remove the " in your data.

Reward if find useful

topic Weird excel file in Application Development and Automation Discussions

Weird excel file

Re: Weird excel file