Formula Tool - Trim Left

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!

Topic of Interest

Accepted answers

atcodedog05

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 : )

Replace.yxmd

All comments

atcodedog05

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 : )

Replace.yxmd

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!

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335