substring or trim a text in coldfusion- help me

[kuolung]

hello,

select account_manager, account_coordinator
from account
where id = 'acct04'

the result will be

account_manager account_coordinator
-------------------- ----------------------
smith,john_MGR jones,sue_COOR

what function in CF can i use to take out the trailing text _MGR and _COOR??? please help.
thanks...

 

[philhege]

Hey erle,

Try

#mid(account_manager,1,find("_",account_manager,1)-1)#

HTH,
PH

 

[kuolung]

it doesn't work and this is what i have as you showed me:

<cfquery name=&quot;myquery&quot; datasource=&quot;myds&quot;>
select account_manager, account_coordinator
from account
where id = 'acct04'
</cfquery>

<cfoutput>
#mid(myquery.account_manager,1,find(&quot;_&quot;,myquery.account_manager,1)-1)#
</cfoutput>

i want to print out just &quot;smith,john&quot;, but the data in table is &quot;smith,john_MGR&quot;

please help again, thanks..

 

[philhege]

What results are you getting? An error? the wrong string?

What?

Post your results so we can figure it out from there.

tks,
PH

 

[kuolung]

thank you, i got it to work now...but i have to take out the -1. thank you so much for you help.

 

[jithreddy]

how to download Oracle data into .csv format by coldfusion templates, I used <cfapplication> but i couldn't sucseeded, any one help me.
Thanks