Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
omerbamba
Contributor
Contributor

SubField Extract

Hi,

Lets say that I have a list in one of my tables that contain data that look like this:

2018_BID_HC Cycle

2018_Stacker_HC Cycle

Now, During the LOAD I want to extract the words between the '_' (BID, Stacker)

I try the SubField Function but it extract only the first '_' (result: 'BID_HC Cycle', 'Stacker_HC Cycle')

Any suggestions?

Thx!

Omer

1 Solution

Accepted Solutions
Anil_Babu_Samineni

May be this?

SubField(FieldName,'_',2)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

1 Reply
Anil_Babu_Samineni

May be this?

SubField(FieldName,'_',2)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)