We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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.
binuacs
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