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  "

[atulggrwl2]

I don't have Alteyx in my System Can you please share jpeg image for better reference

[tjamal1]

[atulggrwl2]

If field1 equals Blank(StaticContent) then New Column Name

[tjamal1]

Blank function is not working 
Can you suggest me the proper formula?

[atulggrwl2]

may be its isBlank as, i don't have access to Alteryx so i don't know how to structured formula properly

[tjamal1]

like this?

[danilang · Accepted solution]

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