then you want a regex like [0-9]{15} it'll find a number set 15 numbers long.
Do I understand you better now? reFindNoCase should return 868487001009190 then if you want to know the position you could do a listFindNoCase pseudo code foundNumber = reFindNoCase("[0-9]{15}", bigString) position = listFindNoCase(foundNumber , bigString) these function params could be in the wrong order etc, but is this kind of what you mean? On Thu, Jul 4, 2013 at 3:13 PM, <rai...@ozemail.com.au> wrote: > *Hi * > > * * > > *I think you misunderstand I will not know what the values of the 15 > character numbers are, that’s the objective finding the 15 character > numbers to the ne able to determine what the actual number value is which > will be different for each record* > > * * > > ** ** > > ** ** > > Kind Regards**** > > ** ** > > Claude Raiola**** > > SAMARIS Software**** > > Call 1300 255 990**** > > * * > > *From:* cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] *On > Behalf Of *M@ Bourke > *Sent:* Friday, 5 July 2013 12:03 AM > *To:* cfaussie@googlegroups.com > *Subject:* Re: [cfaussie] string manipulation to find the value in a > comma separated value record set of a specific length and syntax**** > > ** ** > > ListFindNoCase() ??**** > > On Thu, Jul 4, 2013 at 2:35 PM, <rai...@ozemail.com.au> wrote:**** > > Hi**** > > **** > > I have a csv data set with each record contains a set of comma separated > values**** > > **** > > I am trying to write cf code to interrogate each record to find the value > in the set of comma seated values that meets a specific character set**** > > **** > > In the examples below you can see the value 868487001009190 is located in > position 3 of the first record and position 2 in the second record**** > > **** > > Record 1: > '+RESP:GTSTT,070106,868487001009190,GT500,41,0,0.0,0,14.7,153.035960,-27.471336,20130704121354,0505,0002,1B8D,A281,00,006064939682,-66,20130704122355,0758$' > **** > > **** > > record 2: '+RESP:GTTRI, > 868487001009190,1,0,0,0,0.2,148,6.4,3,153.034551,-27.471390,20130610110953,0505,0002,1B6B,A281,00,0012,0103090402' > **** > > **** > > **** > > **** > > Kind Regards**** > > **** > > Claude Raiola**** > > SAMARIS Software**** > > Call 1300 255 990**** > > **** > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to cfaussie+unsubscr...@googlegroups.com. > To post to this group, send email to cfaussie@googlegroups.com. > Visit this group at http://groups.google.com/group/cfaussie. > For more options, visit https://groups.google.com/groups/opt_out. > > **** > > ** ** > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to cfaussie+unsubscr...@googlegroups.com. > To post to this group, send email to cfaussie@googlegroups.com. > Visit this group at http://groups.google.com/group/cfaussie. > For more options, visit https://groups.google.com/groups/opt_out. > > **** > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to cfaussie+unsubscr...@googlegroups.com. > To post to this group, send email to cfaussie@googlegroups.com. > Visit this group at http://groups.google.com/group/cfaussie. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.