Unable to parse TAB in JSON files

by

From JSON standard:

Insignificant whitespace is allowed before or after any token. The
whitespace characters are: character tabulation (U+0009), line feed
(U+000A), carriage return (U+000D), and space (U+0020). Whitespace is
not allowed within any token, except that space is allowed in
strings.

It means that a literal tab character is not allowed inside a JSON string. You need to escape it as \t (in a .json-file):

{"My_string": "Foo bar.\t Bar foo."}

In addition if json text is provided inside a Python string literal then you need double escape the tab:

foo = '{"My_string": "Foo bar.\\t Bar foo."}' # in a Python source

Or use a Python raw string literal:

foo = r'{"My_string": "Foo bar.\t Bar foo."}' # in a Python source

More Related Contents:

  1. How to read a single object from a json file containing multiple objects using python? [closed]
  2. Split / Explode a column of dictionaries into separate columns with pandas
  3. How do I write JSON data to a file?
  4. How to get string objects instead of Unicode from JSON?
  5. Single vs double quotes in JSON
  6. Reading rather large JSON files [duplicate]
  7. How to JSON serialize sets?
  8. json.dumps vs flask.jsonify
  9. Python/Json:Expecting property name enclosed in double quotes
  10. Python read JSON file and modify
  11. How to get JSON from webpage into Python script
  12. Python’s json module, converts int dictionary keys to strings
  13. Django REST Framework POST nested objects
  14. Serializing a Python namedtuple to json
  15. flattening nested Json in pandas data frame
  16. Python: Trying to Deserialize Multiple JSON objects in a file with each object spanning multiple but consistently spaced number of lines
  17. How to convert to a Python datetime object with JSON.loads?
  18. Cast Flask form value to int
  19. Check if key exists and iterate the JSON array using Python
  20. Serialising an Enum member to JSON
  21. Dump to JSON adds additional double quotes and escaping of quotes
  22. How to return data in JSON format using FastAPI?
  23. Python JSON TypeError list indices must be integers or slices, not str
  24. How to send JSON as part of multipart POST-request
  25. How to create a FastAPI endpoint that can accept either Form or JSON body?
  26. json reading error json.decoder.JSONDecodeError: Invalid \escape
  27. Converting Flask form data to JSON only gets first value
  28. How to make JSON flattening memory efficient?
  29. How to flatten a nested json array?
  30. How to convert csv to json in python?

Leave a Comment