Hello,
I have various csv file in which a lot of columns have numbers starting with 0 (009 or 00231231 or whatever else). If I open the csv file directly, automatically it cuts all the zero in front of that number. If I made any changes to this file and I save back the file, I lose the formatting for all the numbers starting with 0.
The only solution I know it is to create an xlsx file and import the csv file and during the import to set as string these columns. But this operation generates a table and a query. I do not want this.
I would like to modify directly the csv file if possible.
In my specific case, what I would like to achieve is to delete various columns from the csv file before and then import the truncated file in excel with the data import function.
How to do it?
Bookmarks