Get File Extension from a file path

[Sanket_Makwana]

Hello all,

I feel like this should be easier but I’m unable to find a solution.

If I assign vExampleVariable as a variable to the value C:\Users\testuser\Documents\Example.xlsx
(Using assign activity…vExampleVariable = “C:\Users\testuser\Documents\Example.xlsx”)

I want to extract the file extension (.xlsx) from the file path and re-assign it back to vExampleVariable so the final value of vExampleVariable is .xlsx

Ideally it should work for all file extensions and any file path.

Thanks

[ppr (Peter Preuss)]

@Sanket_Makwana

“C:\Users\testuser\Documents\Example.xlsx”

[Sanket_Makwana]

Ahh so simple, thank you!