Pull data from a large field?

[Danny_Bonnadouche]

I have a variable which contins: MEISTER 56767 CB5-325-3-M-84-55 IGE 60DEG 6.5MMX14/M4.5 (G-213 MOD); FSP100:034250006500001; FSP200:RSRV-189

I need to get the FSP100:034250006500001

It's always prefixed with FSP but is in a different place each time. How would I go about getting that out of my variable?

[SafariTECH]

Assuming you only want the FSP100 and not the FSP200...

Try "ListContains" along with "FSP100:" as the criteria and semi-colons as the delimiter

It will tell you what position in the list it is found, then use ListGetAt to pull that list record

[-__cfSearching__-]

Danny Bonnadouche wrote:
> How would I go about getting that out of my variable?

Is this also your question here ?
http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=7&threadid=1390530&ente...

[BKBK]

There is an answer in your other post. Davidsimms has effectively wriiten the code for you. Don't double-post.