alphanumeric sting identification

PARA

how to write a code to identify alphanumeric values in a column using visual recipe.

arnaudde

Hello Para,
You can use the "Extract with regular expression" processor to check if a column contains only alphanumerical characters.

In a prepare recipe you can click on "Add a new step", search for regex, and click on "Extract with regular expression".

If you want to check if the column contains only alphanumerical content you can :
- put "^[a-zA-Z0-9_]*$" in the regular expression field
- and check 'create a special found column'

If you want to extract all alphanumerical occurrences :
- you can put "([a-zA-Z0-9_]+)" in the regular expression field
- and check "extract all occurrences"

Hope it helps,
Arnaud

PARA

this is not working the new column says false for this values "ABC000006498287"

arnaudde

Hello Para,
I can't reproduce your issue. As you can see in the screenshot, the regex works well for a cell with only "ABC000006498287" in it.
Now if you have other characters in the cell it will fail. For instance, I added a trailing space in line 2.

Hope it helps