Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter out rows that begin with three letters in text file

45179902
8 - Asteroid

I have a text file that includes a lot of rows. I want to filer out all the rows that begin with three letters. For example,

B12821392073

IPS 323231233

B31238920382

IPT 123289328

CES 31231232

I want to get "IPS 323231233", "IPT 123289328" and "CES 31231232".

Since this is a text file, I assume RegEx + Filter tool combination is needed.

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @45179902 

 

Your hunch is right here is how you do it.

 

Workflow:

atcodedog05_0-1641890698058.png

 

Hope this helps : )

 

Christina_H
14 - Magnetar

You can use RegEx directly in a filter tool: REGEX_Match([Text], "\u{3}.*")

Christina_H_0-1641890807958.png

 

45179902
8 - Asteroid

Thank you @atcodedog05 and @Christina_H for your prompt responses! 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @45179902 

If our response works please don't forget to mark it as solution.

Cheers and have a nice day!

Labels