Discussion Board for collaboration on QlikView Scripting.
In my dashboard i'm loading a field that can contain email addresses, i would like to remove or scramble these email addresses.
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?
Go to 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
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
thanks for the attention