Eliminating the last character of a string

[Hillary]

For some records in the database, last name field ends with ^. I want to trim this character off where it exists. I am using an If statement but how do I only trim the right most character? This is what I have so far...

If Right({CSL_STD_DEMO_DISTRICT.FIRST_NAME},1) = "^" then TrimRight({CSL_STD_DEMO_DISTRICT.FIRST_NAME},1) else
{CSL_STD_DEMO_DISTRICT.FIRST_NAME}

The TrimRight part of the statement is not correct.

Thanks for your help!

Hillary

 

[dgillz]

This should do it:

if <<condition>> then left({YourString},Length({YourString})-1)


Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[synapsevampire]

If instr({CSL_STD_DEMO_DISTRICT.FIRST_NAME},&quot;^&quot > 0 then mid({CSL_STD_DEMO_DISTRICT.FIRST_NAME},instr({CSL_STD_DEMO_DISTRICT.FIRST_NAME},&quot;^&quot-1) else
{CSL_STD_DEMO_DISTRICT.FIRST_NAME}

-k

 

[synapsevampire]

If instr({CSL_STD_DEMO_DISTRICT.FIRST_NAME},&quot;^&quot > 0 then mid({CSL_STD_DEMO_DISTRICT.FIRST_NAME},instr({CSL_STD_DEMO_DISTRICT.FIRST_NAME},&quot;^&quot-1) else
{CSL_STD_DEMO_DISTRICT.FIRST_NAME}

Or you might just use the following instead:

Replace ({CSL_STD_DEMO_DISTRICT.FIRST_NAME}, &quot;^&quot;, &quot;&quot

-k

 

[Hillary]

Thanks everyone. I used the Replace statment and it works great

Hillary