How to find the index of the first alpha numeric character in a string

[npd]

Hello Users,

I have a requirement to find the index of the first Alpha numeric Character.

Example:

Input:      output 

,,..Apple   4

&&CAR    2

Thanks in advance

[BrandonB]

There may be a more elegant way, but this works: 

[binuacs]

@npd 

[kelly_gilbert]

@binuacs - watch out - the non-word character class (\W) also excludes underscores (so your solution wouldn't handle _123, for example). Also, I'm not sure if @npd's requirement needs to handle something like A.B.C, where there are non-alphanumeric characters after the first alphanumeric.

@npd - here's an alternative regex solution. This will return -1 if the string does not contain any alphanumeric characters.

FindString([input], REGEX_Replace([input], '^.*?[A-Za-z\d](.*)', '$1')) - 1

This finds the rest of the string after the first alphanumeric character.

[apathetichell]

It seems more "Alteryx" to me to do this via tokenizing, tile tool and summarize.