Importing attached file strips backslashes

[tfmorris]

Original author: bil...@gmail.com (September 02, 2010 18:35:18)

What steps will reproduce the problem?

1. Create a new project by importing the attached file (there's only one line in it).
2. Inspect the imported JSON columns. One was escaped using the "html" encoder; the other is raw JSON.

What is the expected output? What do you see instead?

Embedded newlines characters (\n) and UTF-8 characters (e.g. \u201c) in both columns are no longer intact; the backslashes are stripped.

If you use an encoding that also encodes backslashes, such as "url" it works fine. (Something I wish I would have thought of earlier...)

This problem does not appear to occur with simpler files with embedded backslashes; I created a very simple file:

Foo,Bar
Hello\nWorld,3

and it worked fine.

What version of the product are you using? On what operating system?

Trunk, Windows 7.

Original issue: http://code.google.com/p/google-refine/issues/detail?id=121

[tfmorris]

From dfhu...@google.com on September 28, 2010 03:36:30:
Fixed by r1369.