Forum Discussion
Data truncation while performing text to columns for a CSV file
Hi,
I have a CSV file with semicolon as delimiter which is huge event log downloaded from UPS. There are 169 datas seperated using semicolon in one cell which I need to seperate to 169 different column cells. But while I perform the same the data getting truncated and one 1st 6 column data is only getting populated in different cells. Please help.
1 Reply
yasinji Did you just double-click on the CSV to open it? If so, try to import it via the Data ribbon, From Text/CSV.
