Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extracting data and text.
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
extracting data and text.
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. "Aligahk06" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
extracting data and text.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting data from large text files for beginner | Excel Worksheet Functions | |||
Extracting Data from a string of text in a cell | Excel Worksheet Functions | |||
Extracting Numeric Data from a Delimited Text String | Excel Worksheet Functions | |||
extracting text data in a cell | Excel Worksheet Functions | |||
extracting data from a text string of varying length | Excel Discussion (Misc queries) |