Data Importing Wizard - Terrible Data Set - delimiter issue

spicoli1234

New Member
Joined
Oct 30, 2019
Messages
2
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?
yBBGcpF

HTML:
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

RasGhul

Well-known Member
Joined
Jul 15, 2016
Messages
612
Hi,

You made need to create a conversion sheet with text formulas to convert your data..is there any way to clean up the export file before you try to import?
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
49,531
Office Version
  1. 365
Platform
  1. Windows
Could we see 5-10 rows of sample 'messed up' data and the corresponding 'cleaned up' results with any further explanation you can give?
 

Forum statistics

Threads
1,137,155
Messages
5,679,923
Members
419,862
Latest member
Bluewings666

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top