replace an empty values with "N/A" using replaceText processor

[#1]

in the flowfile I have two attributes address and city, and both of them are returned empty. thank you for your help

[#2]

The format of the flowfile is Json

{

"Name": "XXX",

"Address": " ",

"city": " ",

"Country": "USA"

}

but I want it to show like this instead

{

"Name": "XXX",

"Address": "N/A ",

"city": " N/A",

"Country": "USA"

}

[#3]

@Sam LL

Search for white space in double quotes and replace that with "N/A"

Search Value

"\s"

Replacement Value

"N/A"

Character Set

UTF-8

Maximum Buffer Size

1 MB //needs to change this value according to your flowfile size

Replacement Strategy

Regex Replace

Evaluation Mode

Entire text

[#4]

@ShuThank you very much