Hi all-
I have a file titled GDW Analyst Refresh Month day 4 digit year (e.g. GDW Analyst Refresh August 3 2021). I selected the option to pull the file name in as a field so I could isolate the date and append it to my outputs. The below function worked successfully for my July file but I am having some difficulties with August that I can't put my finger on. As you can see from the images below, I cannot successfully isolate the date (it either appears as ugust 3 2021 or h August 3 2021). Let me know if anyone has any suggestions!
Thanks in advance!
Solved! Go to Solution.
Hi @727
Use below formula
Replace([Text], "GDW Analyst Refresh ", "")
Should do the trick. Trim function is a risky function which can trim more than expected. Basically trim functions all characters in whichever order it is.
Hope this helps : )
It works! Thank you 🙂
Happy to help : ) @727
If the response helps please don't forget to mark it as solution.
Cheers and have a nice day!