Export 16 digit value as String in CSV from Database

vidya821 — Sat, 16 Nov 2024 06:56:05 GMT

Dear All,

I am trying to extract a report from DB in csv.

The column in the DB is Varchar and the value is a 12 digit number.

After the export the value is treated as number by the excel once we open the file.

is it possible to force export the value as String from DB into csv ?

E.g 934581347349,

this is exported as number however this is stored as varchar in DB which is displayed as 934581E+11

Now if i am trying to update some other column in same csv file and save it then the above value is changed to 934581000000(935E+11),

when talend reads this csv file it reads it as 935+11

Pease suggest any solution to make sure that 934581347349 is exported as 934581347349 and even reimported as 934581347349

Note: The export and import file format has to be csv

Thanks

Vidya

Re: Export 16 digit value as String in CSV from Database

TRF — Fri, 04 Jan 2019 17:13:14 GMT

The problem is due to Excel which consider a cell containing digits only as a number.
You can try to concatenate a single quote with the value with the following expression "'"+row1.myField but you will probably have to remove it when you will read the file again with the next job.
Hope this helps.

topic Re: Export 16 digit value as String in CSV from Database in Talend Studio

Export 16 digit value as String in CSV from Database

Re: Export 16 digit value as String in CSV from Database