Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Select only PDF names

JDong
8 - Asteroid

Hi Team,

 

I have the below data :

 

orange.pdf
apple.pdf
Prange_apple.pdf
Pina242s&/.pdf
Pineapple__1_2_3.pdf

 

Now I want to extract all the data except the .pdf

 

Output 

 

orange
apple
Prange_apple
Pina242s&/
Pineapple__1_2_3

 

Can you please advise?

 

Thanks!

1 REPLY 1
Towers
11 - Bolide

hi @JDong ,

this should work for you.

Screenshot 2023-07-24 155719.png

Labels
Top Solution Authors