Trim Right with Wildcard

Hi,

I have a field with multiple '.' in the string. I am trying to remove the last instance of this, but the last word in the string varies in lenght. It there a way to trimright([field], '.*') so it alwasy just removes the last '.abcdf'?

ex.

pages.0.questions.2.answers.choices.0.text to pages.0.questions.2.answers.choices.0

pages.0.questions.2.answers.choices.0.id to pages.0.questions.2.answers.choices.0

Thanks a lot.

Regex

Parse

Accepted answers

MarqueeCrew

Quick answers:

Regex_Replace([text],"(.*)([.].*)$",'$1')

Alternatively

GetWord(ReverseString(Replacefirst(Reversestring([text]),' ')),0)

A couple of ideas from my iPhone

All comments

MarqueeCrew

Quick answers:

Regex_Replace([text],"(.*)([.].*)$",'$1')

Alternatively

GetWord(ReverseString(Replacefirst(Reversestring([text]),' ')),0)

A couple of ideas from my iPhone

ddye

Thank you very much. That is perfect.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703