In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

Alteryx Designer Desktop Discussions

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

using regex to extract file extension

OEvangelista
7 - Meteor

Hello, 

 

I have the following filenames:

   aaaaaaa.xlsx

   bbbbbbb.csv

   ccccc.pdf

 

I am pretty new using the regex tool.

How would I create the Regular Expression to parse the above filenames and just show the file extensions (i.e.. xlsx, csv, pdf, etc.)?.

 

Thanks

4 REPLIES 4
MarqueeCrew
20 - Arcturus
20 - Arcturus

@OEvangelista ,

 

Answer:  You wouldn't.

 

You would use this function:  FileGetExt(Path)

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
binu_acs
21 - Polaris

@OEvangelista one way of doing this

 

binuacs_0-1654636714735.png

 

OEvangelista
7 - Meteor

Thanks!!!

OEvangelista
7 - Meteor

Thanks for offering a different tool set!!!

Labels
Top Solution Authors