topic Search string based on a character and remove or scramble in QlikView

Search string based on a character and remove or scramble

twanqlik — Thu, 01 Feb 2018 10:41:21 GMT

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

Example:

Desired output:

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 — Thu, 01 Feb 2018 10:44:57 GMT

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 — Thu, 01 Feb 2018 13:12:41 GMT

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 — Thu, 01 Feb 2018 13:22:31 GMT

fixed

thanks for the attention