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

paulmiddleton

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

Aaron_Berson

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

Hi @Aaron_Berson - thanks for the assist! @paulmiddleton hopefully that works for you, if not - please feel free to reach out here again!