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
