Data Importing Wizard - Terrible Data Set - delimiter issue

[spicoli1234]

Hello,

I have a wonky .txt file. I have to import the data into excel and I use data import wizard. Column B and C have data in there that should be split out into different fields (ie, anothercolumnthing, trans id, anothercolumn, event-time). However, I cannot get the data to be delimited correctly, and sometimes the long string number is changed to scientific notation even though the data wizard characterized the column as text. Someone on a mac, during data import changed it to unicode 8 and started the import on row 2 and it worked. I cannot start the import from row 2. You might ask, why can't you change the original file and delete the first row. The .txt original file is a wierd cascading string and doesn't really have a set row, etc.

Any ideas?

https://ibb.co/VVzHrnD

 

[sandy666]

duplicate

https://www.mrexcel.com/forum/excel...wizard-terrible-data-set-delimiter-issue.html

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).