tPatternMasking - Mask on street name of address field

[Anonymous]

Hi,

I have a table that has address fields and wanted to mask the building number or number in the street.

Street name field pattern is something like this house_number<spaces or comma>streetname(includes spaces or comma) and I wanted to mask only the house number.

The output can be <rondom house_number><spaces or comma>streetname(includes spaces or comma).

How can I achieve this.

I am trying using tPatternMasking  giving Column to mask as STREET

1. with Interval - "1,999"

I do not want to mask street name.

I am getting null for all values. Please advice.

Thanks

[Anonymous · Accepted solution]

Hi,

tPatternMasking is great to mask what can be represented as a pattern (e.g. SSN, IBAN, etc.). An address does not really match this case.
I would recommend that you extract the first number of your string, mask it separately (or even generate a random number which seems to match your use case), and then concatenate this generated number with the rest of your address.

Regards,

Patrick