unday, 7 July 2013 6:35 PM
> To: rai...@ozemail.com.au
> Subject: Re: [cfaussie] string manipulation to find the value in a comma
> separated value record set of a specific length and syntax
>
> If you send me a few samples perhaps I can help?
>
> Paul Kukiel | CTO
> IMG
From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of
Charlie Arehart
Sent: Friday, 5 July 2013 8:44 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
: Friday, 5 July 2013 8:44 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
Claude, you don't mention how you are reading the csv in, in the first
place. Are you using CFFILE or an
Claude, you don't mention how you are reading the csv in, in the first
place. Are you using CFFILE or another function to read the entire file in,
and then trying to loop over it?
Have you instead tried using CFHTTP? Many don't know it but that has long
had the ability to read in a CSV and convert
I realise it is not - in your example but...
If the position of the number s always at the same position in the list;
You can use ListGetAt()
Otherwise you can loop through the list using the regex of the other posts
to find your match.
Lastly, depending on the length of the CSV, and the lists t
I understand you want to know the column in the record, then do a
ListToArray and loop though each element to look for the pattern, use
"^[0-9]{15}$" to look for value that are exactly 15 chars.
Chris
--
Chris Velevitch
Manager - Adobe Platform Users Group, Sydney
m: 0415 469 095
www.apugs.org.au
la
>
> 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
aiola
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
ListFindNoCase() ??
On Thu, Jul 4, 2013 at 2:35 PM, 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 th
