Replace function for a column

[cloh021]

Hi Guru,

I have a column named "item name" with the below row items:

ItemName

Apple -- January

Pear -- January

Apple -- February

Apple -- March

Apple - December

How can I replace the month to Mmm and also replace -- to - at the same time?

Thanks in advance!

[IraWatt]

Hey @cloh021,

You could do this all at the same time with one formula tool using the regex replace and datetime parse. I've attached the a workflow which does it step by step which is a littler more understandable. The formula replaces '--' with '-' then the regex parse takes the information after the - which the datetime tools then convert to MMM. Finaly the formula tool replaces Month with MMM.

I've attached the workflow down below.

Any questions or issues please ask :)
HTH!
Ira

[DataNath · Accepted solution]

One way of doing this @cloh021 :)

Edit: Couldn't help myself, had to throw in the single tool option as @IraWatt mentioned!

[Qiu]

@cloh021 
There is another way that we can prepare a static input, Month Vs Mon.
So we can use a Find and Replace tool to do it.

[IraWatt]

😆Nice one @DataNath ! looks a lot cleaner then what I thought it would look like.

[binuacs · Accepted solution]

@cloh021 Another way of doing this with the Left function 

[Qiu]

@binuacs 

That is a good one and OOTB thinking. 😀

[ddiesel]

@binuacs One tool for the win! 

[cloh021]

Thanksss all Guruss! It all works! 

[MarqueeCrew]

@ddiesel ,

You might like 1 expression within 1 tool (Formula) for the win :)

GetWord([ItemName], 0) + " - " + left(GetWord([ItemName], 2),3)

No RegEx for the Ex-tra points.

Cheers,

Mark