Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Splitting Rows
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) -- Regards Michael Koerner |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Splitting Rows
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 On Fri, 7 Nov 2003 16:25:04 -0500, "Michael Koerner" wrote: 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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Splitting Rows
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 "DavidP" wrote in message ... 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 On Fri, 7 Nov 2003 16:25:04 -0500, "Michael Koerner" wrote: 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) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Splitting Rows
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 { On Sat, 8 Nov 2003 08:59:10 -0500, "Michael Koerner" wrote: 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Splitting Rows
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 "DavidP" wrote in message ... 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 { On Sat, 8 Nov 2003 08:59:10 -0500, "Michael Koerner" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting rows in a worksheet | Excel Discussion (Misc queries) | |||
Splitting Rows - AGAIN | Excel Worksheet Functions | |||
Splitting Rows | Excel Discussion (Misc queries) | |||
Splitting Rows | New Users to Excel | |||
Splitting Rows | Excel Discussion (Misc queries) |