split large CSV file into large number of columns (without truncating the column)

[dizy_11]

Hi all,

I'm working with a large CSV file which will have large number of columns when will convert to excel. I used \0 as delimiter to import whole file. Then I used regex and text to column tool to remove inappropriate symbols. Finally in the output, lots of the columns from the right end side is truncated. 

Can anyone please suggest me a solution from which all the columns can appear without truncating any.

Thanks in Advance for helping 🙂

[Qiu · Accepted solution]

@dizy_11 
Do you try to increase this size?

[dizy_11]

Thanks a lot for helping. Actually I'm new here so didn't know that.

Thanks

[Qiu]

@dizy_11 

That is perfectly normal. 😁 and I am happy to help.