Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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