Replace and expression

[PrMc]

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

to

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

[Felipe_Ribeir0 · Accepted solution]

Hi @PrMc 

You can do it with this formula

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

[gautiergodard]

hey @PrMc 

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

[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