Search string based on a character and remove or scramble

[twanqlik]

In my dashboard i'm loading a field that can contain email addresses, i would like to remove or scramble these email addresses.

Example:

Field
info@test.nl
New York
Belgium
Honda
Qlikview

Desired output:

Field
NULL or wlegh#)*%_
New York
Belgium
Honda
Qlikview

Hence, in my script i think i first need to search on values in my Field that can contain an @, and after that remove it, or scramble it.

Any ideas on how to do this?

[ali_hijazi]

you can use the following script:
load if(wildmatch(field,'*@*'),autonumber(field),field) as field

autonumber converts the string value to a number

you can use other functions like Hash128 and other

check help for more details

[sunny_talwar · Accepted solution]

I think it should be more like this (you missed an asterisk at the end of the string)

If(WildMatch(field, '*@*'), AutoNumber(field), field) as field

you can make it more precise by adding the .* also.

If(WildMatch(field, '*@*.*'), AutoNumber(field), field) as field

[ali_hijazi]

fixed

thanks for the attention