Convert text to columns

K

Krish

I need to convert a .txt file which has data without a commas.
00120* ROASTED RED PEPPER SPREAD RETAIL 44.590 CS
02951*GORDAL OLIVES UNPITTED 2/5 LB 59.910 CS

The first 5 characters represent the product number and the text followed by
until the space is the Product description, then Pack size, Price and Unit
of Measure.

Seeking from the experts the best way to convert this data to columns
without much hassle.

Thanks.

Krish
 
B

Bob Bridges

Seems to me you might have to do this in two bites. The first import would
by column-dependant - "fixed width", that is - dividing the text into two
columns, ie the first five bytes and the rest. Then import the rest
space-delimited, marking multiple places as one. Would that work for you?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Date to Text 2
convert to text problem 2
Can I convert text to columns in a query? 2
convert text file to excel 2
Text to columns 6
Text to Columns Macro 7
Converting Text to Date using "Text to Columns" 5
convert string to columns 1

Top