cancel
Showing results for 
Search instead for 
Did you mean: 

Replace "@" and "#" while converting XML to JSON

ppankaj88
New Contributor II

Hi All,

I am converting XML file to JSON file using XML parser snap and JSON formatter.

When I’m converting, prefix “@” is getting added to all the attributes. For example:-

In XML → “ProviderPaxRef”: “String”
In Converted JSON → “@ProviderPaxRef”: “String”

Now I wanted to remove prefix “@” from every element dynamically. Can anyone help me on this.

Regards,
Pankaj

3 REPLIES 3

Supratim
Contributor III

@ppankaj88 Try this binary to document snap then replace(/[@]/g, ‘’) .with content

ppankaj88
New Contributor II

Replace function is not working, could you please share an example.

After using doc to binary snap(make decoding as none) take one mapper and use
$content.replace(/[@]/g, ‘’)