How to remove extra periods from a string field

[Adarsh_R]

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

[Adarsh_R]

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

[afv2688 · Accepted solution]

Hello @Adarsh_R ,

How about this?

Regards

[jacob_kahn]

Hi @Adarsh_R 

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

I've attached an example workflow.

Jacob

[ChrisTX]

Another RegEx option:

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

Chris

[Adarsh_R]

Thanks, Chris and everyone for your help...