How to separate part of a existing column into a new column

Hello I need to use a right function (like excel) to grab part of an existing column. For example:
Report Title: John Smith Week Ending 01-17-20 I want to grab that date at the end of the Report Title and put in a new column. I can't use substring as depending on the characters in someone's name, the string number of the characters I want could be different. In Excel it would be the right function since the date is always at the end of the report title. Right (A1:8) would give me 01-17-20
Comments
-
Hey @paulmiddleton I am assuming that the 01-17-20 is the report auto submit date. If so I believe this would work {report:autoReporting:end}
Also I am assuming you have a report title default, the formula should be there which is generating this in the policy so you should be able to find that and use it as well.
-
Jason Li Expensify Success Coach - Admin, Expensify Team, Expensify Student Ambassador Posts: 231 Expensify Team
Hi @Aaron_Berson - thanks for the assist! @paulmiddleton hopefully that works for you, if not - please feel free to reach out here again!