Importing Data from Text file to proper format

[noal]

Hi all,

I am in a pickle with a set of customer data that is currently in a text file. I am trying to convert this file to more organized manner.

Example: ****These are not actual data but masked data****

Text file look like this

"WEI SUET SI","91125056257","" 31,"WEI SUET SUM","91125625062","" 46,"WEI SUET
TOH","91124891330","" 30,


I am trying to organized my data into
Example:

Column1 ___ Column2 ___ Column3 ___ Column4
WEI SUET SI ___ 91125056257 ___ "" ___ 31
WEI SUET SUM ___ 91125625062 ___ "" ___ 46
WEI SUET TOH ___ 91124891330 ___ "" ___ 30


and so on..

****These are not actual data but masked data****
Attached is the example of the text file
test1.txt


I tried using the delimited function in Excel but it didn't result the formatting that I want
I seek advise from all the guru here.

Thank you.

[patel45]

strange file format, there are some hex 0A characters, it's not easy to import

[noal]

Is there any simple way to organized this file ?

[patel45]

try this code

Please Login or Register  to view this content.

[noal]

I combined this code with some delimited function and
this code work like a charmed. Thank you so much.

Problem solved appreciate it alot.