Extract and split data

Annie

New Member
I spied rows in a table dynamically and extracted details from the table, row by row using"Recognise text with OCR".Now having all the details in the format of text in a single row how do i split each detail within this data item into corresponding columns in a collection.Even if the data is missing in that column it should map columns accordingly.Tried using Utility-String,Regex but couldn't.Can anyone kindly suggest.
 

VJR

Well-Known Member
Hi Annie,

The splitting will depend on how you have got the data in the data item.
Is there some "separator" character like comma etc OR space OR TAB OR XX number of characters OR something that will help to identify on what basis should the text be split into different columns?
 

VJR

Well-Known Member
Hi Annie,

- What type of application are you using - Windows, Web based, etc?
- Are you unable to spy using any of the other available modes which gives the data from a table directly into a collection?
 

Annie

New Member
Web based application
Only surface automation ( recognise text with OCR)identified the results none of the modes worked and resulting error would be no injector when spied using AA and not hooked when spied using windows mode
 

VJR

Well-Known Member
Web based application
Only surface automation ( recognise text with OCR)identified the results none of the modes worked and resulting error would be no injector when spied using AA and not hooked when spied using windows mode
Ok, you might want to try using List Region of Region mode - List Region.
 
Top