Data truncation while performing text to columns for a CSV file

[yasinji]

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.

[#2]

@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.