Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have string like this ALERT:GE-EU-DK-VALS001 -Telia Traffic -IN
I wan to get the GE-EU-DK-VALS001
Try,
=mid(Field, index(Field,':')+1, index(Field,'-',4)-(index(Field,':')+1))
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.
Try,
=mid(Field, index(Field,':')+1, index(Field,'-',4)-(index(Field,':')+1))
=Left(SubField('ALERT:GE-EU-DK-VALS001 -Telia Traffic -IN',':',-1), Index(SubField('ALERT:GE-EU-DK-VALS001 -Telia Traffic -IN',':',-1),'-',4)-2)
There are several ways
Textbetween(); mid();, combine left() and right()
Try textbetween( YourFieldName, ':', ' ') as NewField
I am not sure if the format changes
Colin's TextBetween example should be fine, but it would be good to see a few more sample strings to verify the assumed pattern.
It's not working for
ALERT:GE:PE:EU:DV001-Telia Traffic -IN
left(SubField('ALERT:GE-EU-DK-VALS001 -Telia Traffic -IN',':',2),16)
Can you give me example for above string?