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

[puttemans]

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.

[Kushal_Chawda · Accepted solution]

Try,

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

[trpatel123]

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

[Colin-Albert]

There are several ways

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

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

[Kushal_Chawda]

I am not sure if the format changes

[Ralf-Narfeldt]

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

[#8]

It's not working for

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

[sasiparupudi1]

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

[#10]

Can you give me example for above string?