remove abbreviation

lulu50
lulu50 used Ask the Experts™
on
Hi,

I have a field in the database that list the states like this.

StateName

Alaska (AK)
Arizona (AZ)
Arkansas (AR)
California (CA)
Colorado (CO)
Connecticut (CT)
Delaware (DE)
Florida (FL)
Georgia (GA)
Hawaii (HI)
Idaho (ID)
Illinois (IL)

what I want is to output the field like this

<cfoutput>#DispChDetail.StateName#</cfoutput>

the result should be without the abbreviation

like this

Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
Florida
Georgia
Hawaii
Idaho
Illinois

I don't want to remove the abbreviation from the database because I need it to display it with abbreviation in a different place.

just on one page that I don't want the abbreviation.
How can I remove it.
 
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
you can treat is a list

<cfset temp = listfirst(DispChDetail.StateName,"(")>

#temp#
Brijesh ChauhanStaff IT Engineer
Commented:
<cfoutput>#left(DispChDetail.StateName,(Find('(',DispChDetail.StateName))-1)#</cfoutput>
lulu50Web application

Author

Commented:
Thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial