Thanks Pierre. It worked. Looks like I was doing something wrong inside my
workflow.
Would not be it feasible to have an option for EvaluateJsonPath processor
to have an option to return escaped or unescaped JSON result?

On Mon, Apr 25, 2016 at 7:20 AM, Pierre Villard <pierre.villard...@gmail.com
> wrote:

> Hi Igor,
>
> Please use ReplaceText processors.
>
> 1.
> Search value : \\
> Replace value : Empty string set
>
> 2.
> Search value : "\{
> Replace value : \{
>
> 3.
> Search value : \}"
> Replace value : \}
>
> Template example attached.
>
> HTH
> Pierre
>
>
> 2016-04-24 20:12 GMT+02:00 Igor Kravzov <igork.ine...@gmail.com>:
>
>> I am not that good in regex. What would be the proper configuration to do
>> the following;
>>
>>    1. Remove backslash from text.
>>    2. Replace "{ with {
>>    3. replace }" with }
>>
>> Basically I need to clean escaped JSON.
>>
>> Like before:
>>
>>  
>> "{\"hashtags\":[{\"text\":\"Apple\",\"indices\":[45,51]}],\"urls\":[{\"url\":\"\",\"expanded_url\":\"\",\"display_url\":\"owler.us/abdLas\
>>  
>> <http://owler.us/abdLas%5C>",\"indices\":[64,87]}],\"user_mentions\":[],\"symbols\":[{\"text\":\"AAPL\",\"indices\":[88,93]}]}",
>>
>> after:
>>
>> {"hashtags":[{"text":"Apple","indices":[45,51]}],"urls":[{"url":"","expanded_url":"","display_url":"owler.us/abdLas","indices":[64,87]}],"user_mentions":[],"symbols":[{"text":"AAPL","indices":[88,93]}]},
>>
>> Thanks in advance.
>>
>
>
  • ReplaceText process... Igor Kravzov
    • Re: ReplaceTex... Pierre Villard
      • Re: Replac... Igor Kravzov
        • Re: Re... Aldrin Piri
          • Re... Igor Kravzov
            • ... Aldrin Piri
          • Re... Igor Kravzov
            • ... Aldrin Piri
              • ... Igor Kravzov
                • ... McDermott, Chris Kevin (MSDU - STaTS/StorefrontRemote)
                • ... McDermott, Chris Kevin (MSDU - STaTS/StorefrontRemote)
                • ... Igor Kravzov
                • ... McDermott, Chris Kevin (MSDU - STaTS/StorefrontRemote)

Reply via email to