String function

[#1]

Hi,

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

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

[#2]

Hi,

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

[Ralf-Narfeldt]

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.

[sasiparupudi1]

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

[#5]

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

[Colin-Albert]

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.

[qlikviewwizard]

qvlearn123

[qlikviewwizard]

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.

[Ralf-Narfeldt]

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

[MarcoWedel]

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

hope this helps

Regards

Marco

[maximiliano_vel]

Try

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

OR

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