Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
evansabres
Specialist
Specialist

Trim a Field in Script

I have a field called 'camp_name' for which the data appears as 'Brand Name/Campaign Name'

I want to create a new field from this, in the script, that returns only the text after the '/'. I am not really sure how to go about this.  From my above example, I would want the new field to be called  'newCMPNME' and the result to be 'Campaign Name'

1 Reply
SukumarBera
Contributor III
Contributor III

Please can you give a try with
Subfield(camp_name,'/',2) as newCMPNME

Regards,
Sukumar Bera