Parsing of field

Davidsimms has effectively wriiten the code for you. Oh, and don't double-post.

rjproctor wrote:
> OK, the listlen will give me the no of semicolons, but there are multiple semicolons and the item that I need isn't always after the 3rd semicolon but it is always after the FSP100:

Then you are looking for a regular expression search using the ReFind()
function. A read of the documentation for ReFind() and how to use the
resulting structure maybe in order.

<cfdump var="#refind('FSP100:(.*?);','MEISTER 56767 CB5-325-3-M-84-55
IGE 60DEG 6.5MMX14/M4.5 (G-213 MOD); FSP100:034250006500001;
FSP200:RSRV-189',1,true)#">

OK, the listlen will give me the no of semicolons, but there are multiple semicolons and the item that I need isn't always after the 3rd semicolon but it is always after the FSP100:

rjproctor wrote:
> Yes it is, so how do I parse the field to parse within cf to see the semi-colons

If one where to read some of the ColdFusion documentation concerning
it's list functions, one would learn that all the list functions allows
one to specify the list delimiting charatcer(s) as a parameter of the
function.

I.E. <cfoutput>#listLen('MEISTER 56767 CB5-325-3-M-84-55 IGE 60DEG
6.5MMX14/M4.5 (G-213 MOD);FSP100:034250006500001; FSP200:RSRV-189',';')

Yes it is, so how do I parse the field to parse within cf to see the semi-colons

Your specific example is a list with semi-colons as the delimiter.