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?
Not sure what you are trying to do? It is just a character, you can use it how ever you want with strings?
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
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.
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
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", "_:")
