Hi Naoko Jones (NaokoJones) ,

Maybe try the filetype here:

http://appstore.sdl.com/app/file-type-definition-for-json/561/

It's far more intuitive than the built in JSON filter.  "Extract" all your rules and then remove the stuff you don't want to see extracted.  So here I just removed the specific ones you mentioned (I ignored the etc. part!):

This then extracts just this:

Regards

Paul

Hi, Paul

the JSON filter is a great plugin, but the structure of my JSON file is a little more complex, here's the example of it:

"ID01": {

"name": [
{
"props": {
"a": "123",
"b": "456",
},
"text": "text need to translate"
}
],

..............

"ID100": {
"name": [
{
"props": {
"a: "653",
"b": "773",
},
"text": "text need to translate"
}
],

as you can see, there are so many IDXX tags( they are random letters and numbers without space), I can't add the Path rules in the JSON filter plugin one by one, is there any regex rules could match this, like     [\a-zA-Z0-9\]\.text    ?  sorry I'm not good at regex. 

Hi, Paul

the JSON filter is a great plugin, but the structure of my JSON file is a little more complex, here's the example of it:

"ID01": {

"name": [
{
"props": {
"a": "123",
"b": "456",
},
"text": "text need to translate"
}
],

..............

"ID100": {
"name": [
{
"props": {
"a: "653",
"b": "773",
},
"text": "text need to translate"
}
],

as you can see, there are so many IDXX tags( they are random letters and numbers without space), I can't add the Path rules in the JSON filter plugin one by one, is there any regex rules could match this, like     [\a-zA-Z0-9\]\.text    ?  sorry I'm not good at regex. 

Hi Xiang Li

The following will capture text content.

$..text

My go-to reference place for JSONPath is:

https://goessner.net/articles/JsonPath/

I hope you will find it useful!

Thanks,

Naoko

Hi, Naoko

the json file:

How to use "$..text" in trados? 

I think I can't use it directly in JSON filter 

Hi Xiang Li

I am using built-in JSON parser, not app store plugin. The below setting extract all values with name "string". In your case, you can use ..text or $..text to extract all values with name "text".