Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Spliting data with multiple delimiters

Hi,

I have some data which have multiple delimiters.

E.g for Movie Genre

Comedy | Romance

Comedy , Romance

Action | Fantasy

Action , Fantasy

I would like to split them into single genre. How can i use subfield() to include both the " | " and " , " delimiters?

Thanks!

1 Reply
MarcoWedel

maybe

SubField(Replace([Movie Genre],',','|'),'|') as [Movie Genre]


?


hope this helps


regards


Marco