Multi field Regex

Hi, I'm looking for a regex expression that I can use into multi field formula tool to extract the text. The empty/template string looks like this:

{"blocks":[{"key":"14qa","text":"","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}}],"entityMap":{}}

If there is text, in this case to be extracted, it looks like this:

{"blocks":[{"key":"c1247","text":"Requires repetitive human interaction to log in to different systems and collect data in a spreadsheet.","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}}],"entityMap":{}}

Regex

Output

Parse

Common Use Cases

Accepted answers

ChrisTX

Try the Multi Field Formula tool with this function:

REGEX_Replace([_CurrentField_], '(.*)("text":")(.*)(","type")(.*)', "$3")

Screenshot 2021-02-25 082941.png

Chris

All comments

TomWelgemoed

Hi @Istwineres ,

This is JSON text - don't you just want to use the JSON Parse tool?

Regards,

Tom

ChrisTX

As mentioned, the JSON Parse tool is the easiest option.

If you want to use RegEx in Parse mode, try this expression: (.*)("text":")(.*)(","type")(.*)

Screenshot 2021-02-25 074433.png

Chris

Istwineres

I know it is JSON text, this is a partial result from a RESTful API get but I get this error " JSON Parse (39) Error message: The document is empty. at character position: 0". Moreover I need to apply to mulltiple fields

Istwineres

I've got this part I'm trying to use in a multi field formula to avoid 8 parse regex tools

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703