![]() | Col0 | Col1 | Col2 | Col3 | Col4 | Col5 | Col6 | Col7 | If you simply remove ^|^, you have a right CSV output.csv ![]() The below is just a sample used for the brevity of this post. Remarks: The actual file is a huge (1GB) file with about 150 columns. Question: What should be a better way of using a custom delimiter in the following file so we don't get ^|^ value in the first and last column? File seems to have come from a source that is using 1252: Western European (Windows) encoding.īy looking at the content of the file, I decided to use ^|^,^|^ as a custom delimiter that seems to work except the the first and the last columns still have ^|^ in their values (as shown in image below). ![]() I am trying to convert following text file into csv by using Text Import Wizard of Data Excel 365. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |