PDA

View Full Version : How to Arrange telephone directory ocr image in excel, in table form



asad75
01-16-2014, 12:53 PM
I am posting two files 'textfilefromocr.doc' is the form of data I got from OCR, then I copy paste that data into excel worksheet named 'rawdata' and created another worksheet named 'requiredform'well that is the eventual form, from there I would export that tabular form as it is, to ms-word
Any swift way to do this thing kindly suggest I am waiting..

ANY OTHER WAY ALSO

asad75
01-16-2014, 12:55 PM
kindly anyone help...........

ashleyuk1984
01-16-2014, 12:59 PM
The data is just a complete mess.
I would suggest trying to find another way of importing your data first.

http://www.ultraimg.com/images/zXS9.png

D_Marcel
01-16-2014, 01:20 PM
The code to organize this would need several "Ifs" to identify and treat all situations here:


1. Name and address in the same cell;
2. Phone beside the Address, below the name;
3. Name, Address and Phone in the same cell;
4. Indexes with phone;
5. Phones in the cells beside (you may use the method 'variableaname.offset(x,y).value' here.
.
.
.

Check if the feature 'Text to Columns' in tab 'Data' can help you somehow.