Replace function for a column

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

Workflow 305.yxmd

DataNath

One way of doing this @cloh021

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

Trim down full month in ItemName.yxmd

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.

0530-cloh021.yxmd

IraWatt

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

binu_acs

@cloh021 Another way of doing this with the Left function

ReplaeMonth_30_05.yxmd

Qiu

@binu_acs

That is a good one and OOTB thinking. 😀

ddiesel

@binu_acs 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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703