Stripping a line

  • Thread starter Thread starter insane
  • Start date Start date
I

insane

Hi. I`m new here and just wanna know something.

I`ve got a .txt doxument with about 3000 lines in it that has to b
split up into different colums at certain markers. could someone pleas
help me out.

underneath i`ve added one line from the document.

60911477190560@MISS@NE@laka@149 BRIDGE MANSIONS@333 CELLIER
STR@SUNNYhill@@0002@149 BRIDGE MANSIONS@333 CELLIER
STR@SUNNYHILL@PHALA@0902@VISAGIE STR@PHALA@806-7587/8463.@MR KLO
30803@1057@6702032453085@19671235405@081243350927@011231231238831@ELIZABET
DRIVE@PHALA@30123-0885 312354087095/6@WAITER@14277\
 
You didn't say what the markers are. The @ symbols? If that's correct and you
want to split at EVERY @ symbol, use Data/Text to Columns. It has a "Wizard".
There's more information in Help if you need it.
 

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

Stripping a line 1

Back
Top