How to remove extra periods from a string field

Hi,

I have values like

ACC.BBB.TM
C.QMM.UZZ
DH.QPP.Z

I require the data like

ACCBBB.TM
CQMM.UZZ
DHQPP.Z

No extra periods in between..

Thanks in advance for the solution

Regex

Parse

Common Use Cases

Expression

Accepted answers

Hello @Adarsh_R ,

How about this?

Regards

remove extra periods.yxmd

All comments

Hello @Adarsh_R ,

How about this?

Regards

remove extra periods.yxmd

In your example, you can use the ReplaceFirst function to get the job done.

I've attached an example workflow.

Jacob

ReplaceFirst.yxmd

Another RegEx option:

REGEX_Replace([your_field], "\.(?=.*\.)", "")

Chris

Thanks, Chris and everyone for your help...

Quick Links

Tags

This months top contributors