You could do listtoarray(mydbfield, "�") It will get all the info out into an array for you. You'll have to put the � sign back in though.
Paul > -----Original Message----- > From: James Buckingham [mailto:[EMAIL PROTECTED] > Sent: 15 January 2004 12:35 > To: '[EMAIL PROTECTED]' > Subject: [ cf-dev ] NEWBIE - Dividing a string by a > particular character > > > Hi there, > > I'm currently working on my very first Cold Fusion project > and I've hit a bit of a stumbling block; so I was wondering > if any of you veterans out there could help me out :). I'm > sure this is very simple!!! > > I have a field in my DB called fares which contains a single > string in each of the records. The string looks something like this: > > �562.50�562.50�587.50�562.50�445.00 > > Each fare is to correspond with a date which is stored in > exactly the same way. I've managed to split the date up ok as > this is a set number of 8 characters but the prices could > vary a lot so I'm needing to split it up by the � character. > I've been looking at the left,mid and right functions but > I've not managed to find anything on how to implement it in > this particular way. Can anyone point me in the right direction? > > Cheers in advance, > JamesB > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
