Formula Tool - Trim Left

[727]

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!

[atcodedog05 · Accepted 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 : )

[727]

It works! Thank you 🙂 

[atcodedog05]

Happy to help : ) @727 

If the response helps please don't forget to mark it as solution.

Cheers and have a nice day!