bmohdz21 / google-refine

Automatically exported from code.google.com/p/google-refine
0 stars 0 forks source link

feature request: data has column shifts in some rows #247

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Open a space-delimited file of names with some one-part names (such as 
"SMITH") and some two-part names (such as "DI GREGORIO") in Google Refine
2.
3.

What is the expected output? What do you see instead?
Well, this isn't a bug report, it's a feature request -- I see "SMITH" and "DI" 
in my last_names column, and in the DI GREGORIO record all columns to the right 
are shifted. I'd like to be able to combine columns in selective batches, and 
also move column entries in selective batches.

What version of the product are you using? On what operating system?
Google Refine version 2.0, on Windows XP Pro.

Please provide any additional information below.

Original issue reported on code.google.com by PhilaDe...@gmail.com on 22 Nov 2010 at 7:08

GoogleCodeExporter commented 9 years ago
I'm not following what you are requesting here.  If your field separator is 
included in your data, your only choices are to: 1) quote the contents of the 
field, 2) choose a different separator or 3) escape the separator.  Spreadsheet 
and database tools typically go with solution #1.  ie for your data, output "Di 
Gregorio" and "Smith"

What solution would you like to see?

Original comment by tfmorris on 23 Nov 2010 at 12:03