Your subscription could not be saved. Please try again.
Your subscription has been successful.

Subscribe to receive our monthly OpenRefine roundups with new tutorials, release updates and community announcements.

10.9.12

Error: smartSplit error: Un-terminated quoted field at end of CSV line

I am a big fan of the smartSplit function. It is really easy to understand and help to extract quickly part of a string based on any character. However if while using the smartSplit function a cells contains a double quote - " - sign, google refine will return the following error message
Error: smartSplit error: Un-terminated quoted field at end of CSV line

Here is my work around.


Issue

In our example we want to extract links from a tweet. As a tweet could have multiple link I split its content in multiple cells based on the string http and then transpose all the new column into one.

Now I want to extract only the first word of each cell, for this I use the following function:
value.smartSplit(' ')[0]
and I get the following preview:


As you can see, my first cells returns the error:
 Error: smartSplit error: Un-terminated quoted field at end of CSV line

This is due to the  double quote - " - mark in the string.

Solution

Before using the smartSplit function remove all quotation mark and then re run the smartSplit function. This will solve your problem!


This post was

0 comments:

Post a Comment