Answered
Swapping field values
I have a location value coming from a database that has the
value 'Main/Offshore' but I want to be able to swap the word 'Main'
for 'UK'. I have put in the code:
<cfif #mid(location,1,5)# IS "Main/" >UK
<cfelse>#location#
</cfif>
but this swaps the whole value and shows only UK. I want it to show UK/Offshore. Is there a way I can do this?
<cfif #mid(location,1,5)# IS "Main/" >UK
<cfelse>#location#
</cfif>
but this swaps the whole value and shows only UK. I want it to show UK/Offshore. Is there a way I can do this?
AdChoices