Originally posted by: MarieWallace

I am using ITX to transform a huge CSV file into JSON. The file contains special characters (e.g. <VT>) that need to be escaped otherwise they will invalidate the JSON. I thought I could use Item Restrictions (Character/Exclude) to exclude special characters and replace them with the reference string, however this doesn't appear to work as I expected. It just marks the field as invalid, but doesn't do any mapping.

Any help would be HUGELY appreciated. There may be another way to handle these escape characters, and I'm easy, as long as I can prevent them from corrupting my JSON.

Originally posted by: PaulBrett

Please find attached the simplest example of using a restriction list to replace certain characters.

You will note that the 'TextItem root' object has the list, which includes the <VT> sequence.  My input data has the hex '0B' character in line #2

My output line #2 is:

'Input data%0Bline 2'

The <VT> having been replaced with a URL encoded %0B as an example.

Thank you.

Paul

Follow me on Twitter

Attachment(s)

VT_Escape.zip   2 KB 1 version

Originally posted by: MarieWallace

Thanks so much for your help. This did the trick, I had gotten the strings in the wrong order. Much appreciated.