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

Designing Pipelines
#1

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

#2

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

#3

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

#4

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