topic Re: How do I use keep the middle string and nothing else? in QlikView

How do I use keep the middle string and nothing else?

Mon, 16 Feb 2015 22:36:54 GMT

I have a strong of information that looks like:

ON-1055661-1

I want the middle string in order to connect to another database that uses only that part of the data, but I can't figure out how to remove it consistently, since the first and last string can vary greatly. (Not by the number of characters in each, but with what the characters are).

I tried using subfield '-' so that it looked at each string independently, but there is so much clutter now.

Re: How do I use keep the middle string and nothing else?

Colin-Albert — Tue, 17 Feb 2015 00:34:33 GMT

Subfield(yourfieldname, '-', 2) will extract the string within the dashes.

Re: How do I use keep the middle string and nothing else?

sunny_talwar — Tue, 17 Feb 2015 02:32:35 GMT

So all the records within this field will have a similar structure? xxxx-xxxx-xxxx (with xx can vary in number?) If this is the case then Subfield should work for you. If not, then is there any kind of symmetry among the records?

Best,

Re: How do I use keep the middle string and nothing else?

jagan — Tue, 17 Feb 2015 04:06:20 GMT

Hi,

If all the values are in the same format then you can use

SubField(FieldName, '-', 2)

OR You can also try

TextBetween(FieldName, '-', '-')

Regards,

Jagan.

Re: How do I use keep the middle string and nothing else?

Tue, 17 Feb 2015 15:42:37 GMT

Thanks everyone who answered, the first answer did the trick!