extracting data and text.

A

Aligahk06

Dear All,

Greetings of the day!!!!!
I have an excel file with bulk of contents in following format.
Col A contains description, Colc Contains (Size inches to the corresponding
description)
Col D contains the Qty. to the corresponding Description.

I want to fetch form ColA i.e( Only Pipe and ELL as a text from entire
string.)
i.e if pipe is available in string then fetch it or if ELL is available in
same string then fetch it.
But in each string only either pipe will bet there or ELL will be there or
nothing.
Possibilty of finding the string is One( i.e either pipe or ELL not both in
same string.)

From column C the corersponding inches i want to fetch.
From column D the corersponding Qty. i want to fetch.

From All three columns appear contents respectively in ColE, COlF and Col G.

Basically this is for compilation of requisite data only.
Note:- The excel file is converted from Pdf file.

Please assist with any formula or macro or the logic you can share.
 
J

JLatham

You could do this with formulas:
In E2
=IF(ISERR(FIND("pipe",A2)),IF(ISERR(FIND("ell",A2)),"","ELL"),"PIPE")
in F2
=IF(E2="","",C2)
in G2
=IF(E2="","",D2)
and fill down the sheet. Then filter by non-blank in column E to see only
those items found.
 
S

Simon Lloyd

Also posted here 'VBA Express Forum
(http://www.vbaexpress.com/forum/showthread.php?t=29040) there may b
others

Aligahk06;544655 said:
Dear All

Greetings of the day!!!!
I have an excel file with bulk of contents in following format
Col A contains description, Colc Contains (Size inches to th
correspondin
description
Col D contains the Qty. to the corresponding Description

I want to fetch form ColA i.e( Only Pipe and ELL as a text from entir
string.
i.e if pipe is available in string then fetch it or if ELL is availabl
i
same string then fetch it
But in each string only either pipe will bet there or ELL will be ther
o
nothing
Possibilty of finding the string is One( i.e either pipe or ELL no
both i
same string.

From column C the corersponding inches i want to fetch
From column D the corersponding Qty. i want to fetch

From All three columns appear contents respectively in ColE, COlF an
Col G

Basically this is for compilation of requisite data only
Note:- The excel file is converted from Pdf file

Please assist with any formula or macro or the logic you can share

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com
 
B

bla bla

Interesting points on extracting data, For extracting data i use
python for simple things,data extraction can be a time consuming
process
but for larger projects like documents, files, or the web i tried <a
href="http://www.extractingdata.com">"extracting data from the web"</
a> which worked great, they build quick custom screen scrapers,
extracting data, and data parsing programs
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top