Import Text Wizard issues

rxp409

New Member
Joined
Apr 27, 2010
Messages
17
Hi
I have a text file containing data which shows correctly in a web browser, looks like garbage in notepad, then when i import it through the text wizard using space as the delimiter it shows correctly except that some of the rows are shifted across by one column and others aren't. For example

STRIKECALLVTYDELTAGAMMATHETAVEGA
8222.010100
8519.010100
85.518.510100
97.56.5312.50.981.610
986.03100.991.070
98.55.5411.30.972.30
995.05100.972.410
99.54.5710.60.953.790.01
1004.08100.944.650.01
100.53.619.40.925.770.010.04
1013.149.10.897.40.01
101.52.698.80.869.370.010.06
1022.268.80.8111.540.01
102.51.858.40.7513.850.010.09
1031.478.10.6816.160.02
103.51.137.80.618.180.020.11
1040.837.70.5119.140.02
104.50.597.50.4119.030.020.11
1050.47.30.3117.760.01
105.50.257.10.2315.50.010.08
1060.167.10.1612.390.01
106.50.17.20.119.380.010.06
1070.067.30.076.740.01
107.50.047.30.044.600.03

<tbody>
</tbody>

So from strikes 82 to 100 all of the data has been shifted right one column, which is ok i can deal with that. But from then on each alternate column is out of line. This happens throughout the file across hundreds of sets of data. What should i be looking for? I've tried changing the file origin to ANSI and 1252 etc but no change.

NB: in the pasted sample above i've not included the far left column, but obviously that is correspondingly out of line too, there is no missing data.
 
Last edited:
I see what you mean now with the spaces added at the start of the strikes shifted right, its a shame they couldn't format it using tabs. I tried using fixed width which fixes the problem for the grid of data. However it ruins the data at the top of each table which i also need. I have a few hundred of these files, o i guess i'd have to do two passes of each where i could extract the data from the table and then the head.

By chance does anyone know if this kind of file would be easily uploaded into a database? I have little to no experience of them but i would be interested in it if that would work.

Cheers for your help
 
Upvote 0

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

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
Back
Top