show just certain part of the string!

I'm having a big problem.
I'm pulling information from a AS400 server.
In that server they have a file with a field named "Title" that when they populate that field they also added the year of publication of the book, and if the book was Trade or textbook, and also if the book comes with a CD or other extra "material", anyway......

This is the title that I pull from the as400 server
"ADVANCED MACROMEDIA COLDFUSION 5 02 MACRO PB TRD OP"

but I want it to just show

"ADVANCED MACROMEDIA COLDFUSION 5"

since all the titles have a two digits "year" I was wondering if anybody knew how to truncate or just show everything on the title that is on the left of the "year" in this case the 02...

PLEASE I NEED HELP!

Look at the string functions, specifically left(), mid(), findNoCase(), etc.

If you always know that the string you want will end in "02" then you can just find that and then select everything to the left of it. But if you don't know what the actual values for the server name or the year will be this will be much more complicated. How can you know where the title of the book ends and the year and the other info begins?

Well that's the problem... sometimes it might end in 01, 97, 98 or 02, or 99 or any other year... that is the problem.

The best you can do is loop over the field and find the first element that is two numbers in a row (ie '97'), and then select everything to the left of that. Without some way to differentiate between the title and the year, that's your only option.

Something like:

<cfset mystring = "ADVANCED MACROMEDIA COLDFUSION 5 02 MACRO PB TRD OP">
<cfoutput>#LEFT(mystring,REFind(" [0-9][0-9] ",mystring)-1)#</cfoutput>