topic How to extract alphanumeric digits from column in Alteryx Designer Desktop Discussions

How to extract alphanumeric digits from column

Luk88kk — Tue, 18 May 2021 12:39:29 GMT

Hello everyone,
I am a beginner user of Alteryx.
I need to extract products starting with 3 alpha-numeric digits for example:
F09999R98
0F6987U76
00T467T9T

If a product starts only with letters or numbers e.g. 128, TES... it should be removed or moved to another column.

I will be very grateful for your help. As I mentioned I am new and so far this problem is overwhelming me.

Re: How to extract alphanumeric digits from column

atcodedog05 — Tue, 18 May 2021 12:47:09 GMT

Hi @Luk88kk

You can use below formula

IF REGEX_Match([Field1], "^\u{3}.*") or REGEX_Match([Field1], "^\d{3}.*") THEN "No" ELSE "Yes" ENDIF

REGEX_Match([Field1], "^\u{3}.*") is checking whether is starts with 3 letters and REGEX_Match([Field1], "^\d{3}.*") is checking whether is starts with 3 numbers. If it doesnt start with either of them then it flags it as Yes (its a mix). You can perform further action as required

Workflow:

Hope this helps 🙂

Re: How to extract alphanumeric digits from column

jdunkerley79 — Tue, 18 May 2021 12:57:53 GMT

Fairly similar to @atcodedog05

I suggest a formula tool with an expression like:

!REGEX_Match([Field1], "^(\d{3}|\u{3}).*")

The REGEX_match will return true if the first 3 are just numbers of letters. The ! in front of it makes it inverted so T output is when mixed.

Re: How to extract alphanumeric digits from column

Luk88kk — Tue, 18 May 2021 14:11:06 GMT

Hello,

I have applied both solutions and they work.
Thank you so much.

Re: How to extract alphanumeric digits from column

mceleavey — Tue, 18 May 2021 17:52:16 GMT

Hi @Luk88kk ,

I built this using the regex tool to parse out the values matching that pattern:

Hope this helps.