Assign a desired text output based on the first character of a field 1

[DeniseF1204]

I'm using a field named (USERDEF2) that generates the following information:

1usABC
2usABC
3usABC
4usABC

I want to create a formula that can help me generate the following output:

if USERDEF2 field begins with the #1 (Example:1usABC) then I want "CompanyName1" to appear.

if USERDEF2 field begins with the #2 (Example:2usABC) then I want "CompanyName2" to appear.

if USERDEF2 field begins with the #3 (Example:3usABC) then I want "CompanyName3" to appear.

if USERDEF2 field begins with the #4 (Example:4usABC) then I want "CompanyName4" to appear.


Your suggestions are appreciated.

Thank you.

 

[lbass]

Create a formula:

select {table.USERDEF2}[1]
case "1" : "CompanyName1"
case "2" : "CompanyName2" //etc.
default : ""

-LB