tags:

views:

54

answers:

1
+1  Q: 

Data needs conversion into columns from multiple-address-object-blocks (Excel / OpenOffice )

Each block contains 3 addresses - name, city, state, zip - how do I break it apart in OpenOffice/Excel?

James R. Javier DDS Kent R. Nelson DDS Theodore G. Lund DDS 421 SW 335th St 1911 SW Campus Rd 2748 SW 315th St Federal Way, WA 98023-6192 Federal Way, WA 98023-6473 Federal Way, WA 98023-7832

H. Jung Song DDS Timothy J. Weaver DDS Sang H. Bae DDS 21807 76th Ave W 21701 76th Ave W #202 13426 64th Ave W Edmonds, WA 98026 Edmonds, WA 98026 Edmonds, WA 98026

+1  A: 

Not sure where your data is coming from, but if you could somehow insert a delimiter or implement a fixed field length, the 'text to columns' function in Excel will help. (Data->Text to Columns.)

JT.WK  2009-11-16 23:21:41
The data came from OCR'd "Address Labels" - about 99% came across correctly, about 100-150 records came across as above. looking for quick way that i hadn't thought of..otherwise i might just retype. no way to insert any delimiter...the data is the data. :)
Zachary  2009-11-16 23:23:32
in that case, I don't know of any way to split data that has no consistency or delimiter.
JT.WK  2009-11-16 23:29:46
looks like its a job for the peons! muauahahah :) thanks for trying, i figured it was a no go. the only consistency in the data seems to be what it contains...
Zachary  2009-11-16 23:37:39
Haha no prob! Hope it's not too much work!
JT.WK  2009-11-16 23:43:30
I ended up using Excel extensively and wasting a lot of time. Make proper data models/formats!
Zachary  2010-02-09 16:28:46

related questions

What causes java.io.CharConversionException with EOF or isHexDigit messages in Tomcat?
C# VB.NET Conversion
Tabs and spaces conversion
Converting large ASP.NET VB.NET project to C# - incrementally?
How to migrate SVN with history to a new Git repository?
Best way to convert pdf files to tiff files
How to convert numbers between Hex and Decimal in C#
Using C#, what is the most efficient method of converting a string containing binary data to an array of bytes
How do I programmatically convert mp3 to an itunes-playable aac/m4a file?
Using Java JAR file in .NET
Best way to convert text files between character sets?
Convert from scientific notation string to float in C#
BufferedImage in IKVM
What tools exist to convert a Delphi 7 application to C# and the .Net framework?
Is there a tool that can convert common image formats (.bmp, jpg,..) to .emf files?
XAML to SVG?
Backward Converting SQL Databases
Converting latitude/longitude to Alberta 10 TM Projection
Migrating from ASP Classic to .NET and pain mitigation
PHP ToString() equivalent
Java: Best way of converting List<Integer> to List<String>
Easy way for Crystal Reports to MS SQL Server Reporting Services conversion
CVS to SVN conversion and reorganizing branches
C# Convert Integers into Written Numbers
Are there any conversion tools for porting Visual J# code to C#?