Select only PDF names

[JDong]

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!

[Towers]

hi @JDong ,

this should work for you.