Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

Show part of the values in a field

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

If ' - ' is the delimiter, try

LOAD

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

....

FROM ... ;

View solution in original post

2 Replies
swuehl
MVP
MVP

If ' - ' is the delimiter, try

LOAD

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

....

FROM ... ;

alec1982
Specialist II
Specialist II
Author

This is working just perfect!

Thank you.