Calculate amount of letters and digit in a string

[faiqz]

Hi, I will go straight to the question.

I have a list of business names. For example:

ID	business names
1	Apple Inc
2	21st Century Fix
3	1990 moons

By using Alteryx, I need to find the amount of letters and digits used in the name. For example if the string contain letters (eg :pen) then the result will display '3d'. If the string contains both letters and numbers (eg: 123abc) then the result will display '3t3d'. 't' represent the digits while 'd' represent letters (a-z). if the string contain 3 letters, then the result will display '3d'.

Okay, so for the result of the dummy dataset of the business names above, it will result to this:

ID	business names	result
1	Apple Inc	8d
2	21st Century Fix	2t12d
3	golive90	6d2t

I'm still novice in Alteryx so I haven't explore widely the usage of Alteryx yet. I hope the experts that saw my post here will be able to help and assist me to complete my task. Thank you

[faiqz]

I'm sorry for the inconsistency of the dummy data values in column business names.

[messi007]

@faiqz,

Please see below :

Attached the workflow,

Regards,

[faiqz]

Hi! This is awesome, Thank you for your kind and warm respond. I am just wondering. What if the business names has digits at the end of the string?

For example:

Cat90, the result will be 3d2t

01Apple, the result will be 2t5d

Is it possible to rearrange the pattern according to the string?

[binuacs]

@faiqz I updated @messi007 workflow 

[PhilipMannering · Accepted solution]

Another potential solution. Should be dynamic,

[faiqz]

Hi!

Sorry for the late reply. Yes this is the solution that I want. Thank you, I hope I can be as good as you in using alteryx in the future