Split string on tab delimiter

[linuxyz]

Hi

I need to split a string in a macro depending on the presence of the tab character.

I’ve tried:

MyText = "the first part	this is the second part"
MyArray = Split(MyText, "\t")

But it’s not working.

I’ve tried also:

MyText = "the first part	this is the second part"
MyArray = Split(MyText, "	")

to no avail.

Thanks a lot!

[linuxyz]

It’s :

MyText = "the first part    this is the second part"
MyArray = Split(MyText, chr(9))

Not easy to find!