Remove numbers and . from string

Hi,

I have a number of fund names which have a number and full stop in front of them as follows:

1. My personal fund

23. Johns Pension Pot

301. Mavis Savings

I want to get the following:

My personal fund

Johns Pension Pot

Mavis Savings

Regex

Accepted answers

Hi @craigja you can use Regex replace. I've mocked up a workflow let me know what you think? The syntax \d+\.\s will look for a digit one or more followed by a period and then a white space and replace it with nothing in the field.

Regex_Replace_130421.yxmd

We can also use RegEx_Replace function

New Workflow6.yxmd

All comments

Hi @craigja you can use Regex replace. I've mocked up a workflow let me know what you think? The syntax \d+\.\s will look for a digit one or more followed by a period and then a white space and replace it with nothing in the field.

Regex_Replace_130421.yxmd

We can also use RegEx_Replace function

New Workflow6.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15867

MarqueeCrew 13708

apathetichell 13703