The first row indicates the column headers and the second row is the actual data
Here you can see :
The red color is the first column and its data
The yellow color is the second column and its data and so on…
I just need the column green and its data
@tejastandel007
in such a case an initial analysis will look for following:
is a reliable column seperator available
are key indicators to the value available
for first I dont see a clear seperator on the first look
for second I do see that the Value is the only one in Capital (Upper Letter)
so if we can rely on this indicator then Regex will help us.
have acheck on the rest of data
And always important: if sreensrapping can be replaced with something more precise then this alternate is always welcome. Maybe you can tell some more words about your scenario (what is to do etc)
Data is from desktop application, so data scrapping wont work and i need to get that column “Bl Tkpr” value .The value will always in Upper Letter and it size is not fixed
Could you help me with Regex? as i see there is no such pattern
From same application there is export data to clipboard, but clipboard too contains same kind of data. Above image is from the same
@tejastandel007
regex development could start with following:
use Match activity
About not working Data Scrapping. Sometimes other techniques like get text and changing index or find children can be used. Maybe you share a screenshot with us. Also test if selectors to the different cells /coll can be found with uiexplorer
To keep this process simple, I have extracted data to text file(Bill Name) and now i want to compare(Bill Name) with data in excel sheet. If Bill Name matches then write data to new excel file or text file or datatable
sample text data:
P num Session Company Description Bill Name
123 789 ABCD Any body can do XYZPQR
111 012 DFHH Deal Descrption QWERTY
110 152 CCHH National Description YUIOP
189 172 CCHH Nat Description ACCT01