Splitter.SplitTextByDelimiter with list of delimiters

[Anonymous]

I downloaded a .txt file.  I want to split [Column23] and split at each occurrence of the delimiter.  For my delimiter (with leading and trailing spaces to isolate), how can I use the following list?

Since the list values reoccur (within a row) in [Column23], I can't simply use Splitter.SplitTextByDelimiter in 4 steps (for each list value). Thanks!

Delimiter

D

W

P

X

[tackytechtom · Accepted solution]

Hi @Anonymous ,

Could the Splitter.SplitTextByAnyDelimiter({"Delimiter1", "Delimiter2", Delimiter3"}, QuoteStyle.Csv)) solve your issue? 🙂

Something like this:

= Table.SplitColumn(#"Changed Type", "Column23", Splitter.SplitTextByAnyDelimiter({"D","W","P","X"},
QuoteStyle.Csv), {"Column23.1", "Column23.2", "Column23.3", "Column23.4"}) 

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/