•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I'm looking to pull text from schematics and put the into an excel spreadsheet to create a wiring checklist.
I'm currently using Kofax power pdf to view wiring schematics and want to figure out a way to extract only the cable ID's from the pdf. The cable ID's are all 5-digits or 5-digits with a "C" before the number. I've tried using the "Looks like" feature in Kofax but it includes data outside of my set parameters. Any help with this or a subreddit to help with this would be highly appreciated.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI-powered spreadsheet
#wiring schematics
#cable ID
#Kofax Power PDF
#PDF extraction
#Excel spreadsheet
#wiring checklist
#text extraction
#regular expressions
#data extraction
#OCR
#5-digit numbers
#pattern recognition
#automation
#Looks like feature
#data validation
#spreadsheet
#cable
#schematics
#data