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 just want to export the file to Access manually you can use import feature of Access It will ask where you follow the wizard will help you to export the text file data to Access table later you can import the data to appropriate table. Regards Nagaraj.A ----- Original Message ----- 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 using CFFILE but cannot parse it properly > > This is the file: > > "SUS","BUTTER","1876334568","Attracting Butterflies to Your Garden","CLYNE > DENSEY",23.95,1,"TP","", > > "SUS","CATTLE","0882660667","Family Cow","VAN LOON DIRK",29.95,2,"PB","", > > "SUS","CATTLE","0911311688","Natural Cattle Care ACRES USA ED","COLEBY > PAT",49.50,0,"TP","", > > "SUS","COMPOS","0670904678","Australian Self Sufficiency Ha","SMITH > KEITH",39.95,0,"TP","1992", > > "SUS","CONIFE","1876473312","Gardening With Conifers","BLOOM > ADRIAN",42.90,0,"HB","2001", > > "SUS","COOKIN","0732265517","Best of Jackie French","FRENCH > JACKIE",24.95,1,"TP","", > > "SUS","COWSMI","086417120X","Keeping a Cow","WILSON JIM",0,0,"TP","1987", > > > I don't know how to get rid of the last comma in each line, and then how to > parse with a blank line between each record. > > I've tried this > <CFFILE action="READ" > file="D:\InetPub\wwwroot\_Candelo\database\candeloweb1603.txt" > variable="Candelo"> > <!--- Set a variable to hold the ascii values for a line break and a > carriage return ---> > <CFSET new_line=Chr(10) & Chr(13)> > > > <!--- Loop thru lines of text ---> > <CFLOOP index="i" list="Candelo" delimiters="new_line"> > <cfoutput>#Candelo#</cfoutput><BR> > </CFLOOP> > > > and get this (but repeated three times!) > "SUS","BUTTER","1876334568","Attracting Butterflies to Your Garden","CLYNE > DENSEY",23.95,1,"TP","", "SUS","CATTLE","0882660667","Family Cow","VAN LOON > DIRK",29.95,2,"PB","", "SUS","CATTLE","0911311688","Natural Cattle Care > ACRES USA ED","COLEBY PAT",49.50,0,"TP","", > "SUS","COMPOS","0670904678","Australian Self Sufficiency Ha","SMITH > KEITH",39.95,0,"TP","1992", "SUS","CONIFE","1876473312","Gardening With > Conifers","BLOOM ADRIAN",42.90,0,"HB","2001", > "SUS","COOKIN","0732265517","Best of Jackie French","FRENCH > JACKIE",24.95,1,"TP","", "SUS","COWSMI","086417120X","Keeping a > Cow","WILSON JIM",0,0,"TP","1987", > > > Can anyone give me some clues or help please > > Many thanks > > Seamus > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
