Looking for some help to understand how I can convert the headings which are currently in String format to Date format (Should be in this format: 18-Jan-2021).
Also looking to get an idea on the best way to format and remove the .3 or data appearing after the 2nd "." in the Names of countries such that I am only remaining with Australia.AUS rather than Australia.AUS.2
@Sujithappaiah
Dynamic Rename should be a good fit here.
There looks to be an error in the formula there -
It should be "%d-%b-%Y" instead of "%m-%b-%Y"
Regards,
Ben