Re: parsing problem

Hi - thanks for that. I changed it to rereplace(web_export,([^,]*),(.*)\n(.*)\n[ ](.*)\n,line:\1|\2|\3,ALL) But got this: line:Abbott| John E-mail Address(es): [EMAIL PROTECTED] Abrahams, Fred E-mail Address(es): [EMAIL PROTECTED] Adams, Kerin E-mail Address(es): [EMAIL PROTECTED] Allen, Norman

Re: parsing problem

try this one: rereplace(web_export, (.[^,]*),[[:space:]]+(.[^\n]*)(.[^\n]*)[[:space:]]*(.[^\n]*), \1|\2|\4br, ALL) i used the br in replaced string to visually separate lines on screen. change it to \n or whatever you need to. cheers, Azadi -- Azadi Saryev Sabai-dee.com

Re: parsing problem

Thanks heaps Azadi that worked well Seamus ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now

parsing problem

Hi, I'm trying to parse this list below and am having problems. The list comes to me in this format and I have no control over it. I want to parse it to insert first name, last name, email into a database. I'm trying to read the file and cannot work out a way to have 2 line/para breaks as a

Re: parsing problem

You could use this regular expression: rereplace(file_contents,([^,]*), (.*)\n(.*)\n[ ](.*)\n,line:\1|\2|\3,ALL) This will convert the 3 lines into something like this: line:Abbot|John|[EMAIL PROTECTED] line:Abrahams|Fred|[EMAIL PROTECTED] etc You might have to tweak it a little, but that

xml file/structure parsing problem

Hi I have an xml file which I parse with soxml tag (which changes it to a structure) I then have to update a database with this. The updating is fine - apart from an images tag within each record eg IMAGES IMAGE MAINimage01.jpg/MAIN TNimage02.jpg/TN /IMAGE IMAGE MAINimage03.jpg/MAIN

more on RE:cffile parsing problem

-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 10:48 AM To: CF-Talk Subject: RE: cffile parsing problem You might want to start by replacing ,#Chr(10)##Chr(13)##Chr(10)##Chr(13)# with a pipe

cffile parsing problem

Hi all I have a txt file (I cannot change the format) which I want to insert/update into an access database online. I've been trying to read the file using CFFILE but cannot parse it properly This is the file: SUS,BUTTER,1876334568,Attracting Butterflies to Your Garden,CLYNE

RE: cffile parsing problem

: cffile parsing problem Hi all I have a txt file (I cannot change the format) which I want to insert/update into an access database online. I've been trying to read the file using CFFILE but cannot parse it properly This is the file: SUS,BUTTER,1876334568,Attracting Butterflies to Your Garden

RE: cffile parsing problem

Subject: cffile parsing problem Hi all I have a txt file (I cannot change the format) which I want to insert/update into an access database online. I've been trying to read the file using CFFILE but cannot parse it properly This is the file: SUS,BUTTER,1876334568,Attracting Butterflies to Your

Re: cffile parsing problem

Try treating your file variable as a list...something like: cffile... cfloop list=#Candelo# delimters=,#CHR(13)##CHR(10)##CHR(13)##CHR(10)# ... do whatever you need to do for each line ... /cfloop HTH Hatton Seamus Campbell wrote: Hi all I have a txt file (I cannot change the

Re: cffile parsing problem

- From: Seamus Campbell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 8:22 PM Subject: cffile parsing problem Hi all I have a txt file (I cannot change the format) which I want to insert/update into an access database online. I've been trying to read the file

RE: cffile parsing problem

I think the Key word here is ONLINE. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: nagraj [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 11:41 AM To: CF-Talk Subject: Re: cffile parsing problem Hi , If you