Text Formula Question

[rhoneyfi]

I have a field in my report called "Dealer_Name"..
Several of the Dealer_Name records go like this:
1SEAR
1AMEGL
etc...

Basically, I need to convert the first letter of the record to an asterix. Note: Some of the Dealer_Name records do not have a 1 as the first letter, thus these records do not need to be changed.
I know the coding is pretty simple...I just don't know the syntax. Thanks

 

[dgillz]

You cannot convert the records in your database, but you can make a report of the records look this way. Is this what you want to do?

If so, here is the code:

if left({Dealer_Name},1)="1" then {Dealer_Name} else "*"&right({Dealer_Name},length({Dealer_Name})-1)

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

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[rhoneyfi]

Thanks! The code works great.