Regex help for custom JSON filetype filter

Question

HI there 
 I need to write a custom JSON filetype filter (TRADOS 2021) and am struggling with getting any regex to work for the JSON Paths in Trados Studio. 
 A sample of the JSON paths that would need to be translated are 
 bronze [ 0 ].localisable.title bronze[0].localisable.subTitle bronze[0].localisable.listItems bronze[1].localisable.title bronze[1].localisable.subTitle bronze[1].localisable.listItems bronze [ 1 ].localisable.ctas[ 0 ].text bronze[1].localisable.ctas[ 1 ].text silver [ 0 ].localisable.title gold [ 0 ].localisable.ctas[ 0 ].text 
 I can't get the correct regex identified for the words bronze/gold/silver or the digits inside the []. 
 
 Any pointers would be appreciated 
 
 TIA 
 
 Peter

Paul · Answer

Peter Johnston 
 Perhaps it would help if you shared a snippet of the json file? The expressions look ok at first glance assuming that the structure of your JSON data aligns with these paths. So we're missing info to be able to assist you.

Paul · Answer

Thanks Peter Johnston 
 The file you gave me contained an error in the "ctas" array under the second "bronze" object as one of the objects was missing a key for its value (which is "URL"). I had to fix that first as I couldn't parse your example at all. 
 Here's my corrected file: 
 {
 "bronze": [
 {
 "localisable": {
 "title": "This is Title 1",
 "subTitle": "This is SubTitle 1",
 "listItems": ["List Item 1"],
 "ctas": [
 {
 "text": "Text 1"
 },
 {
 "text": "Text 2"
 }
 ]
 },
 "image": "URL1",
 "ctas": [
 {
 "link": "URL2"
 },
 {
 "link": "URL3"
 }
 ],
 "dates": {
 "start": "26/06/2023",
 "end": ""
 },
 "priority": "2",
 "publications": ["AB", "CD", "EFTG", "csdtggtf"]
 },
 {
 "localisable": {
 "title": "This is Title 12",
 "subTitle": "This is SubTitle 14",
 "listItems": ["Item 2", "Item 23", "Item 33"],
 "ctas": [
 {
 "text": "Text 1"
 },
 {
 "text": "Text 12"
 }
 ]
 },
 "image": "URL",
 "ctas": [
 {
 "link": "URL"
 },
 {
 "link": "IRL"
 }
 ],
 "dates": {
 "start": "28/06/2023",
 "end": "13/07/2023"
 },
 "priority": "3",
 "publications": ["AB", "CsdtggF", "sdtgg", "dsdsd"]
 }
 ],
 "silver": [
 {
 "localisable": {
 "title": "Titlke 1",
 "subTitle": "Titkle 2",
 "listItems": ["Item 1", "Item 33 ", "Item 4"],
 "ctas": [
 {
 "text": "Text 1"
 },
 {
 "text": "Text 12"
 }
 ]
 },
 "image": "URL",
 "ctas": [
 {
 "link": "URL"
 },
 {
 "link": "URL"
 }
 ],
 "dates": {
 "start": "28/06/2023",
 "end": "13/07/2023"
 },
 "priority": "3",
 "publications": ["AB", "CsdtggF", "sdtgg", "dsdsd"]
 }
 ],
 "gold": [
 {
 "localisable": {
 "title": "This is Title 1",
 "subTitle": "Totl 2",
 "listItems": ["Item 1", "Item 2", "Item 3"],
 "ctas": [
 {
 "text": "Text 1"
 },
 {
 "text": "Text 12"
 }
 ]
 },
 "image": "URL",
 "ctas": [
 {
 "link": "URL"
 },
 {
 "link": "URL"
 }
 ],
 "dates": {
 "start": "28/06/2023",
 "end": "13/07/2023"
 },
 "priority": "3",
 "publications": ["AB", "CsdtggF", "sdtgg", "dsdsd"]
 }
 ]
} 
 Then I added all your rules and they seem to work just fine: 
 
 Can you explain what your problem is exactly?

Paul · Answer

Peter Johnston 
 I'm not sure I follow what you want to do. I don't think JSONPath supports regex for key matching. If you want to extract content from the arrays containing the words "bronze", "gold", or "silver", you would have to explicitly use those key names in your JSONPath expressions. 
 For example: 
 
 bronze[*].localisable.title would extract the title from all "localisable" objects in the "bronze" array. 
 gold[*].localisable.ctas[*].text would extract the text from all "ctas" objects in all "localisable" objects in the "gold" array. 
 silver[*].dates.start would extract the start date from all "dates" objects in the "silver" array. 
 
 If you want to apply the same JSONPath expression to the "bronze", "gold", and "silver" arrays, you would need to replicate the expression three times, once for each key. JSONPath also doesn't offer a way to apply a single expression to multiple keys... as far as I know. 
 Have I completely misunderstood you?

Trados Studio > 6. Regex and XPath

Regex help for custom JSON filetype filter