topic Re: String function in QlikView

String function

Fri, 31 Jul 2015 13:34:23 GMT

Hi,

I have string like this ALERT:GE-EU-DK-VALS001 -Telia Traffic -IN

I wan to get the GE-EU-DK-VALS001

Re: String function

puttemans — Fri, 31 Jul 2015 13:38:37 GMT

If each time the first space (' ') is right behind what you need, then with the subfield command you should be able to get it isolated.

Re: String function

Kushal_Chawda — Fri, 31 Jul 2015 13:38:40 GMT

Try,

=mid(Field, index(Field,':')+1, index(Field,'-',4)-(index(Field,':')+1))

Re: String function

trpatel123 — Fri, 31 Jul 2015 13:38:51 GMT

=Left(SubField('ALERT:GE-EU-DK-VALS001 -Telia Traffic -IN',':',-1), Index(SubField('ALERT:GE-EU-DK-VALS001 -Telia Traffic -IN',':',-1),'-',4)-2)

Re: String function

Colin-Albert — Fri, 31 Jul 2015 13:39:05 GMT

There are several ways

Textbetween(); mid();, combine left() and right()

Try textbetween( YourFieldName, ':', ' ') as NewField

Re: String function

Kushal_Chawda — Fri, 31 Jul 2015 13:40:25 GMT

I am not sure if the format changes

Re: String function

Ralf-Narfeldt — Fri, 31 Jul 2015 13:50:43 GMT

Colin's TextBetween example should be fine, but it would be good to see a few more sample strings to verify the assumed pattern.

Re: String function

Fri, 31 Jul 2015 13:51:11 GMT

It's not working for

ALERT:GE:PE:EU:DV001-Telia Traffic -IN

Re: String function

sasiparupudi1 — Fri, 31 Jul 2015 13:52:43 GMT

left(SubField('ALERT:GE-EU-DK-VALS001 -Telia Traffic -IN',':',2),16)

Re: String function

Fri, 31 Jul 2015 13:56:43 GMT

Can you give me example for above string?

Re: String function

Fri, 31 Jul 2015 13:57:53 GMT

Hi,

I cannot use this. sometimes there may be GE-EU-DK-VAL0001

Re: String function

Ralf-Narfeldt — Fri, 31 Jul 2015 14:00:45 GMT

That's why you need to provide some more data so it's clear what the pattern is for splitting the field.

Otherwise we need to guess.

Re: String function

sasiparupudi1 — Fri, 31 Jul 2015 14:04:20 GMT

if(index(string,':')>0, left(SubField(string,':',2),16),string)

Re: String function

Fri, 31 Jul 2015 14:04:49 GMT

In string ALERT:GE-EU-DK-VAL001 -Telia Traffice. only highlighted is variable and sometimes there could or could not be the space before -telia. Rest format is same

Re: String function

Colin-Albert — Fri, 31 Jul 2015 14:07:57 GMT

You need to provide a list of say 10-20 different examples. Without this, you are being given suggestions that only work for one pattern and will fail where the data structure differs.

Re: String function

qlikviewwizard — Fri, 31 Jul 2015 14:14:00 GMT

qvlearn123

Re: String function

qlikviewwizard — Fri, 31 Jul 2015 14:15:31 GMT

Hi qvlearn123

It is always better to provide sample data more to replicate all your requirement.

Please attach the sample application to demonstrate your requirement. Thank you.

Re: String function

Ralf-Narfeldt — Fri, 31 Jul 2015 14:26:44 GMT

Trim(TextBetween(Your_field, ':', '-Telia'))

Re: String function

MarcoWedel — Fri, 31 Jul 2015 20:06:42 GMT

TextBetween(YourFieldName,'ALERT:','-Telia')

hope this helps

Regards

Marco

Re: String function

maximiliano_vel — Fri, 31 Jul 2015 20:26:32 GMT

Try

=TextBetween(PurgeChar('ALERT:GE-EU-DK-VALS001 -Telia Traffic -IN', ' '), ':', '-Telia')

=TextBetween(PurgeChar('ALERT:GE:PE:EU:DV001-Telia Traffic -I', ' '), 'ALERT:', '-Telia')