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.