Text File Delimiter

[tech69]

Hi All

I am using .TextFileOtherDelimiter = "*" to seperate items on an imported .txt file,

When i try and use it twice only one of them works ie...

Please Login or Register  to view this content.

Anyone know how i can apply both conditions?

Thanks

[venkat1926]

I did some experiments. This may not be comprehensive solution.

suppose the data is like this form A1 down which has many type of delimiters
rememner star sign(*) has special meanings in excel either a wildcard indication or multiplications sign so it needs special treatment. You must enter a tilde(~) before star sigb.


a*2
s'4
asd*45
dfg hj
kl


now try this macro . data is split to text to columns and parked in columns C and D
You may work on these lines modifying it and improving it.

Please Login or Register  to view this content.

[tech69]

Thanks... I shall play with it and see what I can do.