Parse Date and replace text

[jenner85]

Hi - I am trying to get "Name" split to the date and then mapping the letter to Actual, Plan or Forecast. I tried a find replace, but it was cutting out the end of the field? Not sure how that is supposed to work. I was going to find the letter, replace with the Measure and then parse out into two columns for date and measure. Any help is appreciated. Thanks! 

Name	Date	Measure
A Aug 2020	Aug-20	Actual
A Sep 2020	Sep-20	Actual
A Oct 2020	Oct-20	Actual
P Nov 2020	Nov-20	Plan
F Dec 2020	Dec-20	Forecast
P Jan 2021	Jan-21	Plan

[AshleyL · Accepted solution]

Hi @jenner85 --

You can use the Regex Tool to parse out the first letter from the Month-Year! You can then use a Formula to update the A,P,F to be Actual,Plan & Forecast! I've attached an example workflow.

If you don't want to use a Regex, you can use Text to Column to parse out the data in the first column based on a space as the delimiter.

Does this help?

Ashley

[T_Willins · Accepted solution]

Hi @jenner85,

You can create the columns in a single formula tool: