Show part of the values in a field

[alec1982]

Hi,

I have a field which has values like this:

Lease

---------

Expense - Lease

Income - Lease

What should I type in the script so the field will show only

Expense

Income

Thanks,

Alec

[swuehl · Accepted solution]

If ' - ' is the delimiter, try

LOAD

subfield(Lease, ' - ',1) as Lease,

....

FROM ... ;

[alec1982]

This is working just perfect!

Thank you.