How to use a mid function

[#1]

Does anyone know how to use a mid function where you grab a word between a delimiter? I have a field that has a name of a location in between a description...

For example (i.e Yellow-California-Medium or Yellow-Utah-Small) but I can't use the location of the character because the location can have different characters (California vs. Utah) so I would need whatever is between the delimiter..

[its_anandrjs]

You can use subfield function for this for your example

Ex:-

LOAD Desc, SubField(Desc,'-',2) as City;

LOAD * Inline

[

Desc

Yellow-California-Medium

Yellow-Utah-Small

];

And you get California and Utah if i understand clearly

[jerem1234 · Accepted solution]

Try this:

=TextBetween(FIELDNAME, '-', '-')

or you can use subfield:

=subfield(FIELDNAME, '-', 2)

Hope this helps!

[#4]

Jeremiah, that works perfectly. Thanks for your assistance!