Add columns between text

tjamal1

I wanted to add a columns between quotations in my json file in recordID 3

for example this should be replaced 

"staticContent": "  "

with 

"staticContent": " column2  "

commed.yxzp

danilang

Hi @tjamal1 

Try this Regex based solution

REGEX_Replace([Field_1], '(.*?: ")( )(")', '$1 '+[Daysoftheweek]+ ' $3')  

The search strings breaks down to this 

(.*?: ") 1st capture group.  All characters up to the ': "' 

( )        2nd capture group.  The single space between the 2 double quotes

(")       3rd capture group.  The final double quote

The replace string is 

'$1 '+  the 1st capture group from above

[Daysoftheweek]+  the contents of the column [DaysoftheWeek].  change this to whatever you need

' $3'    The 3rd capture group 

The end result of this is that the 2nd capture group(the single space between the double quotes) is replaced by the contents of the [DaysoftheWeek] column.   

The results for your dataset are 

Dan

commedv2.yxzp