Hi Charlie
I trust the following will clear up any confusion I have data from mobile devices being sent to my server The listener captures the packet as a record in database table and the content of the packet is stored in a column the database table. This table become my raw data / log table of all incoming data I then need to run a process to determine the value of the imei number that is included in each packet of data (the packet data is csv string format), the imei number tells me which device the data has been sent from. The issue is that different packets received from different devices have their imei number located in different positions within the packet data being sent Given each imei number is of a set length ( 15 characters ) and only contains numeric characters of 0-9 I am trying to determine the best way to find the value of the imei number in each packet received given the position in the string will not always be at the same location within the string Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: [email protected] [mailto:[email protected]] On Behalf Of Charlie Arehart Sent: Friday, 5 July 2013 8:44 AM To: [email protected] 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 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 it to a query (created using the NAME attribute). Once done, you can easily access the rows and columns, including using SQL to do a query of queries, to do filtering or other manipulation. (If you already know of this use of CFHTTP, had you had any luck in using Q of Q to do the manipulation you seek?) The only challenge with using CFHTTP for this is that the CSV file in question does need to be in a web-accessible directory, as you still have to use a URL to point to the CSV. But if that's not an issue or can be resolved, you may be surprised the power if you've never seen/used it. The tag has a few attributes to control things like whether the first line has a header row, what delimiter and qualifier to use (if other than a comma and double-quotes), and more. The feature is documented in Developer's guide: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172 e0811cbec1529c-7fff.html While it's mentioned in the CFML Reference page for CFHTTP, curiously the key attributes for this capability are not mentioned in the initial table of attributes (as seems more typical). Instead, they are listed in a separate table down the page (search for the text, "convert the HTTP response body into a ColdFusion query object", as there is no section header for it): http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e08 11cbec22c24-7ffc.html Finally, here's an example that shows both reading a CSV and processing it with Q of Q (it's listed oddly in a section on using the Cast function for Q of Q): http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172 e0811cbec0e4fd-7ff0.html#WSc3ff6d0ea77859461172e0811cbec22c24-7b7b Hope that helps someone, even if not you, Claude. But if it does not, what aspect still fails to be resolved? It wasn't quite clear from your note (or your subsequent replies to others here). /charlie From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, July 04, 2013 9:35 AM To: [email protected] Subject: [cfaussie] string manipulation to find the value in a comma separated value record set of a specific length and syntax 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.471 336,20130704121354,0505,0002,1B8D,A281,00,006064939682,-66,20130704122355,07 58$' record 2: '+RESP:GTTRI, 868487001009190,1,0,0,0,0.2,148,6.4,3,153.034551,-27.471390,20130610110953,0 505,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 [email protected]. To post to this group, send email to [email protected]. 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 [email protected]. To post to this group, send email to [email protected]. 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
