Spliting data with multiple delimiters

[#1]

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!

[MarcoWedel]

maybe

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

?

hope this helps

regards

Marco