PDA

View Full Version : Extracting data text and so on.



aligahk06
11-01-2009, 12:45 AM
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.)
Attached file is for ref.
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.

hardlife
11-01-2009, 02:34 AM
Please do You can create desired result manually on Sheet2,
for me is not clear what to do with ELL "90 DEG LR ELL., S-STD, BE, A234-WPB-WX"
and also me do not understand english units "3X3/4"
You must show all possible basic imputs in column (INCHES)
in last column it will be probably not difficult to extract strings before "space appears".

Me is wishing You to have a nice day, Pavel :hi:

mdmackillop
11-01-2009, 04:04 AM
Can you repost your sample showing expected results.

aligahk06
11-01-2009, 05:10 AM
Can you repost your sample showing expected results.
Please find the attached sheet in another post.
Title: Delete the row if null else .

Hope it helps in finding the solution.I have had already done and looking some other problem.

Rgds,
Aligahk06

mdmackillop
11-01-2009, 06:01 AM
Reply posted here (http://www.vbaexpress.com/forum/showthread.php?t=29040)