SPLIT with multiple delimiters? (general VBA question)

[Maury Markowitz]

Is there an analog of SPLIT that allows you to select more than one
delimiter? I often get text files that have both commas and semis in
them.

Maury

 

[RDub]

Replace the Semi's with Comma's and then have at it.

YourString= Replace(YourString,";",",")
YourArray = split( YourString,",")

Rdub

 

[Mike Painter]

Is there an analog of SPLIT that allows you to select more than one
delimiter? I often get text files that have both commas and semis in
them.

Maury

Not even in Pick Basic, but you can use Replace (a weak version of a Pick
function) and change the semi to a coma.
Just make sure that these always function as the same kind of delimiter.