Hi there,
I am trying to validate a JSON file I have, and suspect there it contains it a non ASCII character (as this is the error I get when trying to import it into Tableau). I’m hoping someone here can help me find a way I can search my JSON file to find where it is! I do not know what character it might be.
Thank you for any advice you can give!!
I was going to suggest some free online JSON validators like https://jsonformatter.curiousconcept.com/.
But if Tableau gives a concrete error message about ASCII, then https://stackoverflow.com/questions/2124010/grep-regex-to-match-non-ascii-characters
Awesome, thanks! That second one worked - I found it!
BTW do you know of a JSON Validator compatible with large files? I often work with >1M lines of JSON, but haven’t been able to find a validator capable of doing it