Can ":" be a delimiter?

[#1]

I need to delimit a string that contains a colon ":" as a delimiter.  I can replace all instances with something else.  Can I use it literally?

[#2]

Not sure what you are trying to do? It is just a character, you can use it how ever you want with strings?

[#3]

Hi,

If you try to extract a substring from a string, you can define any delimiter you want (See example below) 

Word( 1, "AAA:BBB:CCC", ":" )

If you need to import a text file with ":" as a delimiter, I suggest uploading the raw text into one column and splitting it using the Column Utilities > Text to Columns (defining the column separator as ":").

If neither approach meets your needs, please share an example of what you are trying to achieve.

Best,

TS

[#4]

I guess I had the source of the problem defined incorrectly.  If I include ":" as a delimiter together with "_" I seem to be getting red ink and a failed formula.

[#5]

Hi,

If you need to specify multiple delimiters with the Word function, it's a single character string containing all the delimiters. For your example, you would specify ":_" as the third argument to Word.

Monica

[#6]

Ah.. So you wish to have two strings to separate using Word? Add all the delimiters into the same string and it should work

Word(2, "A_B:C", "_:")