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 ?
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
Solved! Go to Solution.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables