Import text with more than one delimiters

[ymeyaw]

Dear experts,

If i have more than one delimiters in text and i cant use the import wizzard (default is 1 for user to key in), how should i do that with codeｓ？　I studied some webpages mentioned something bout SplitMultiDelimsEX but still dont really know how it works. Let say the text below is text file and how would i import into excel? With each delimiters seperate the columns?




ABC123|DSC924_BARU02|4297_adf.Danau_KNM1_13|13|102-12-9078-42971|5011-012-50001-30-37371|10662|103|0|
CFG345|ASC924_BARU02|4297_ddd.Danau_KNM1_13|13|102-12-9078-42972|5011-012-50001-30-37371|10662|103|0|



Thanks for your guidance !!...

 

[Gerald Higgins]

Hi, are you saying that you have more than one delimiter character, such as

|

and

,

?

If so, here's some ideas.
I haven't tried them myself, but they might work.

1) Use find and replace, for example to find "|" and replace with ","
Then your delimiters will be standardised.
You could maybe do this in whatever software creates the text file.
Or do it in Excel.
2) If one of the delimiting characters always occurs in consistent locations, import the file using the OTHER delimiter, and then use Data, Text to Columns, to break up whichever columns have the first delimiter.