Remove all before "period" character

[suarezr]

I am working on parsing a JSON output that has multiple rows in the downloaded data. The goal being to get the JSON converted into a CSV dataset.

The best option I have found so far is Substring, but I would rather use REGEX instead of looping through this formula n times.
Substring([JSON_Name],FindString([JSON_Name], ".")+1,Length([JSON_Name]))

I have also tried these, but neither works.
REGEX_Replace([JSON_Name], ".*.\s", "")
REGEX_Replace([JSON_Name], ".*\\.", "")

[apathetichell · Accepted solution]

REGEX_Replace([JSON_Name], ".*.\s", "") looks at any characters - any number of characters, a single any character and a space --- that doesn't seem like what you want..

try ---- regex_replace([JSON_NAME],"^(.*)\.(.*)$","$2")

[suarezr]

Thanks!

I also figured out an alternative using REVERSESTRING, that works as a FindString-based alternative

ReverseString(Left(ReverseString([JSON_Name]),FindString(ReverseString([JSON_Name]),".")))