Need help with queries

%3CLINGO-SUB%20id%3D%22lingo-sub-1815612%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20queries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1815612%22%20slang%3D%22en-US%22%3EHi%2C%20not%20sure%20where%20to%20start%20with%20this%20one%20-%20I%20have%201%2C000ish%20pdfs%20which%20I%20need%20to%20trawl%20for%20data.%20I%20can%20do%20this%20manually...%20but%20would%20like%20to%20automatically%20cut%20out%20much%20of%20what%20I%20don't%20need%2C%20and%20highlight%20parts%20I%20do%20need.%20Unfortunately%20I%20am%20not%20legally%20able%20to%20show%20the%20data%20for%20clarity.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20a%20list%20of%20master%20data%2C%20i.e.%20customers%20and%20job%20numbers.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20planning%20to%20dump%20pdf%20content%20in%20to%20excel.%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20If%20the%20job%20number%20is%20in%20a%20standard%20format%2C%20but%20muddled%20among%20other%20characters%20on%20an%20excel%20cell%2C%20how%20do%20I%20return%20the%20job%20number%3F%20With%20vlookup%20I%20am%20currently%20returning%20the%20value%20of%20the%20line%20with%20the%20partial%20match.%3CBR%20%2F%3EI.e.%20I'm%20looking%20for%20%22X1%3F%3F%3F%3F%22%20And%20i%20just%20want%20to%20return%20%22X1%3F%3F%3F%3F%22%20instead%20of%20%2219F-X1%3F%3F%3F%3F-CC9%22%20or%20%22AX1%3F%3F%3F%3F-01%22.%3CBR%20%2F%3E%3CBR%20%2F%3E2.%20Similarly%2C%20I%20want%20to%20search%20customer%2C%20by%20partial%20match%20of%20name%20or%20abbreviation%20buried%20in%20text%2C%20but%20only%20return%20the%20TLA.%3CBR%20%2F%3E%3CBR%20%2F%3E3.%20I%20want%20to%20pull%20any%20row%20values%2C%20let's%20say%20over%2020%20characters%2C%20below%20cell%20with%20value%20%228.%20General%20Info%22%20and%20above%20cell%20with%20value%229.%20Section%20Nine%22.%3CBR%20%2F%3E%3CBR%20%2F%3E4.%20Let's%20say%20my%20values%20retuned%20at%20%223.%22%20go%20to%20column%20D%2C%20I%20also%20want%20B%20and%20C%20filled%20with%20the%20values%20at%20%221.%22%20and%20%222.%22.%3CBR%20%2F%3E%3CBR%20%2F%3EOn%20an%20aside%2C%20I%20should%20shortly%20have%20access%20to%20power%20query%20if%20that%20will%20help.%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20this%20is%20somewhat%20clear%20-%20I'll%20try%20and%20knock%20up%20some%20dummy%20info%20if%20required.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20in%20advance.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1815612%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor
Hi, not sure where to start with this one - I have 1,000ish pdfs which I need to trawl for data. I can do this manually... but would like to automatically cut out much of what I don't need, and highlight parts I do need. Unfortunately I am not legally able to show the data for clarity.

I have a list of master data, i.e. customers and job numbers.

I am planning to dump pdf content in to excel.

1. If the job number is in a standard format, but muddled among other characters on an excel cell, how do I return the job number? With vlookup I am currently returning the value of the line with the partial match.
I.e. I'm looking for "X1????" And i just want to return "X1????" instead of "19F-X1????-CC9" or "AX1????-01".

2. Similarly, I want to search customer, by partial match of name or abbreviation buried in text, but only return the TLA.

3. I want to pull any row values, let's say over 20 characters, below cell with value "8. General Info" and above cell with value"9. Section Nine".

4. Let's say my values retuned at "3." go to column D, I also want B and C filled with the values at "1." and "2.".

On an aside, I should shortly have access to power query if that will help.

Hope this is somewhat clear - I'll try and knock up some dummy info if required.

Thanks in advance.
0 Replies