Pull data from a large field?

Forum|Forum|17 years ago
September 5, 2008
3 replies
543 views

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?

Advanced techniques

This topic has been closed for replies.

BKBK

Community Expert

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

-

-__cfSearching__-

Inspiring

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&enterthread=y

S

SafariTECH

Inspiring

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded