Problem in exporting into excel when Separator in txt files is "|"(vertical bar) instead of ","

[anuradhagrewal]

Hello
Can anybody tell me a VB script wherein I have to export multiple txt files where the separator is instead of "," is "|"(vertical bar).
I have seen multiple codes where the separator is assumed to be a "," but no VB script for "|" which is a separator.

I have uploaded a sample txt file how it looks and there are multiple such files.

Your help is greatly and earnestly appreciated.

Regards

Anu

 

[mohadin]

Do you mean?
&"|"

 

[sandy666]

are you able to use Power Query? (add-in for XL2010)
btw. I don't see any txt file but picture

 

[anuradhagrewal]

Hello
Thanks for the reply
I am using MS Excel 2007

 

[sandy666]

I am using MS Excel 2007

so update your profile to proper excel version

 

[anuradhagrewal]

I cant this the version I have to use if you can provide me a solution in this it will be great

 

[anuradhagrewal]

Do you mean?
&"|"

Yes exactly "|" vertical bar

 

[sandy666]

I cant this the version I have to use if you can provide me a solution in this it will be great

Power Query doesn't work with XL2007 , for XL2010 you will need PQ add-in

 

[anuradhagrewal]

Power Query doesn't work with XL2007 , for XL2010 you will need PQ add-in

Buddy can you give me a solution in MS Excel 2007?
If not thanks for your time

 

[sandy666]

No, you'll need to wait for someone else with vba solution