Is there an option to “treat consecutive delimiters as one” when using the Split Delimited Text into Columns in EasyMorph similar to that feature in excel?
Hi Michelle and welcome to the Community!
There is no option for that in the “Split delimited text into columns” action. However, you can use a lookup table prior to splitting in order to replace repeating commas with a single comma. See the below example:
consecutive-delimiters.morph (4.6 KB)
In the example, I programmatically generated the lookup table so that it can generate as many consequent commas as necessary. Of course, the lookup table could’ve been entered manually but that would be less convenient for me.
Ok thank you for that suggestion. I think that will be the perfect solution!
You’re welcome 