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.
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.