Seamus, What database are you importing this data into and how are you performing the import?
Is this a bit of CF? Or is it a straight import into Access etc? Regards Stephen ----- Original Message ----- From: "Seamus Campbell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 12, 2002 7:28 AM Subject: list delimiter problem > Hi > > I have a list - the format of which I cannot change. One line as an example > below > > "SUS","DECORA","1903141001","Garden Elements, a source book of decorative > ideas to transform the garden","CLIFTON JOAN",45.00,0,"HB","2000", > > Sometimes there is a comma in the title as above so when I am > inserting/updating the contents into a database > > Garden Elements is taken as one field > and > a source book of decorative ideas to transform the garden as another > > I am trying to change the delimiters but I can't work out how to not to > change the comma, for instance, inside the title field > "Garden Elements, a source book of decorative ideas to transform the garden" > > Does anyone have any clues please > > Seamus > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
