Skip to main content

Hi !

 

My data goes as followed: a dimension "property name" shows a list of lodging property names in my city, another dimension "type" tells me what type of lodging each property is.

e.g. "Hotel Atlantic Hotel Lübeck" is a "Hotel" or "Guest house Pension Adler" is a "Guest house"

 

As you can see, the property name starts by default with the type. I would like to remove "Hotel" from "Hotel Atlantic Hotel Lübeck" and also "Guest House" from "Guest house Pension Adler" so to have: "Atlantic Hotel Lübeck" and "Pension Adler".

 

How can I do that with a calculated field ?

 

Thanks !

Romain

5 answers
  1. Apr 28, 2020, 12:18 PM

    Hi,

     

    when you have those like records, REGEXP_REPLACE will help.

    Hi, when you have those like records, REGEXP_REPLACE will help.

0/9000