What is the difference between Text.Split and Text.SplitAny?

The difference between Text.Split and Text.SplitAny is not clear to me. They both seem to use the same syntax and do the same thing. Would someone please explain to me the difference between the two?

+3


source to share


1 answer


Text.Split splits the text at the supplied delimiter (which can be multiple characters), and Text.SplitAny splits the text for each individual character in the supplied delimiter.

eg. Text.Split ("MarcelBeug", "ce") returns

Mar

lBeug



While Text.SplitAny ("MarcelBeug", "ce") returns

Mar

gV

mcg

+6


source







All Articles