Select portion of string

[koolskins]

I am running CR9 on an Informix database and need to select records from two tables where the column "_program" from table A matches "program_id" in table B. However, the
"_program" records all end in ".4GL" and can be from 4-8 characters in length prior to that extension. How do you select only that part of the string upto the ".4GL"?

Thanks.

 

[lbass]

Create a formula:

left({table.program},instr({table.program},".")-1)

-LB

 

[koolskins]

Thanks. That did the trick.