Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If ' - ' is the delimiter, try
LOAD
subfield(Lease, ' - ',1) as Lease,
....
FROM ... ;
If ' - ' is the delimiter, try
LOAD
subfield(Lease, ' - ',1) as Lease,
....
FROM ... ;
This is working just perfect!
Thank you.