Renaming Multiple Records by Single Name

[#1]

Hi All,

I have Product Records with different names that I want to rename the same thing. For example, "S200" ",S200" "200SQL" -- I want all to be named "200" -- is there some kind of 'contains' function in Qlik that allows you to rename records?

Rename Record(Contains '200') as 200

How is this done in Qlik?

Thanks!

David

[#2]

Perfect.  You the man, Max.