Replace and expression

I need to replace the following expressions which I have hundreds of to the ones below.

results.13.geometry.viewport.northeast.lat
results.0.geometry.viewport.northeast.lng
results.2.geometry.viewport.southwest.lat
results.800.geometry.viewport.southwest.lng
results.0.icon
results.70000.icon_background_color
results.3.icon_mask_base_uri
results.0.name

geometry.viewport.northeast.lat
geometry.viewport.northeast.lng
geometry.viewport.southwest.lat
geometry.viewport.southwest.lng
icon
icon_background_color
icon_mask_base_uri

name

Regex

Accepted answers

Felipe_Ribeir0

Hi @PrMc

You can do it with this formula

REGEX_Replace([Field1], 'results\.\d+\.', '')

Replace and expression.yxmd

All comments

Felipe_Ribeir0

Hi @PrMc

You can do it with this formula

REGEX_Replace([Field1], 'results\.\d+\.', '')

Replace and expression.yxmd

gautiergodard

hey @PrMc

here is on quick way to do it using text to columns

ttc.yxmd

ShankerV

Hi @PrMc

One way of doing this with the help of Regex tool.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Replace and expression.yxmd

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335