Splitting Rows

  • Thread starter Thread starter Michael Koerner
  • Start date Start date
M

Michael Koerner

I have the task of scanning in a large number of tables, running them through an
OCR program into Excel. for the most part it works just fine. But, on occasion I
end up getting a number of rows combined into one row. I would like to know if
there might be an easy way of extracting/splitting the information into it's own
row(s)
 
I think we would have to have more information to help you. e.g. Are
there always the same nymber of characters in a row, Is there any
identifiers to aim for such as all rows start with "XXXX" etc

DavidP
 
No, the number of characters can differ. I probably should have tried to be more
explicit.

The rows are laid out in 9 columns. When the OCR program does it correctly, it
looks like this for a single row

R1 xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx

Then I receive the following all in 1 row
xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx
R2 xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx
xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx

What I have been doing, depending on the number of rows inserted into a single
row is to duplicate then manually delete the information from each cell. Using
the R2 example above, create a R3, and R4. Hope this helps. I thought there
might be away to do this with some sort of macro, that would searh for the line
breaks in a cell.

--

Regards
Michael Koerner


I think we would have to have more information to help you. e.g. Are
there always the same nymber of characters in a row, Is there any
identifiers to aim for such as all rows start with "XXXX" etc

DavidP
 
Michael

I am still a little vague as to what info is comming in as the number
od characters appear the same. is it possible to send a sample of a
file that is giving you a problem and I will see if I can sort it for
you

David {
 
David, thanks for going to all the trouble trying to make sense of my jibberish
I think I may have solved the problem, outside of Excel. Before bringing in the
product to the OCR program, I enhanced the lines that represent the rows and
columns, and everything seems to be recognized properly.

It all looked the same just so that it would line up when being read, if that
makes any sense.

--

Regards
Michael Koerner


Michael

I am still a little vague as to what info is comming in as the number
od characters appear the same. is it possible to send a sample of a
file that is giving you a problem and I will see if I can sort it for
you

David {
 
Back
Top