Masking all characters of a Field while keeping the word length

[Morven]

Hi all,

I would like to replace all characters of a Field while keeping the word length

eg. I LOVE BALI ISLAND becomes X XXXX XXXX XXXXXX

or Alteryx is fun becomes XXXXXXX XX XXX

This is for data for an entire column and im wondering how to do it?

[binuacs · Accepted solution]

@Morven Something like this?

REGEX_Replace([Word], '[A-Za-z]', 'X')

[Morven]

Yep! But if now instead of like a simple one that masks all values, I would like to mask it in a way such that if the word has one letter, it is unmasked, 2 and 3 letters and it shows the first letter, 4 letters and 5 letters it shows 2, 6 letters and more then it shows the first 4 letters only,

ie. THIS IS MY FAVORITE HOUSE -> THXX IX MX FAVOXXXX HOXXX

[anandakrishnan]

@Morven 

Please check the below solution

[anandakrishnan]

@Morven 

In this case you can count the length and apply the formula.

Using If condition.

[Morven]

How do you do that? Sorry I'm a little new to alteryx

[Christina_H]

There might be a better way to do it, but this works.  The number of characters unmasked doesn't quite match what you asked for.