topic Re: How to use a mid function in QlikView

How to use a mid function

Mon, 14 Jul 2014 19:23:28 GMT

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..

Re: How to use a mid function

its_anandrjs — Mon, 14 Jul 2014 19:28:17 GMT

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

Re: How to use a mid function

jerem1234 — Mon, 14 Jul 2014 19:28:49 GMT

Try this:

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

or you can use subfield:

=subfield(FIELDNAME, '-', 2)

Hope this helps!

Re: How to use a mid function

Mon, 14 Jul 2014 19:34:19 GMT

Jeremiah, that works perfectly. Thanks for your assistance!