No, it’ll likely be a bit messy when extracted as a CSV with the newlines and everything. But if someone was familiar with the Unix text processing tools like sed, grep, awk and the shell, it would be relatively easy to pull out the desired fields. It looks like the resulting CSV would have one attribute per line, which would be relatively easy to work with in those Unix tools.
Omg that is great, thanks. (Excellent username, btw)
To me, this project positively screams for FileMaker Pro.
Import, script the handling of the results to write out sensibly, export to sensible xlsx file.
I’m now curious how this could possibly be used if you are simply pulling out the bolded portions. Nothing looks proprietary, so if you’re able to share it would be appreciated.
I’m trying to understand how, for example, six rows with the value “Indiana” could be useful without further context. Is it the city of Indiana, IA, the county of Indiana, PA, or the state of Indiana, or some combination of all three? It appears that you are simply generating a list of place names with zero context.
I’m not really looking for Indiana. I have made up data involving states, cities and counties to make it a little easier to read. Really, what I’m looking for is different categories and hierarchies of cost objects with names that wouldn’t necessarily make any sense to someone who doesn’t use this particular system. My real purpose is to compile a list of employees and the payroll cost objects to which they are assigned, whether those cost objects are at the “State,” “City”, or “County” level.
Thanks again, everyone. Extremely helpful. Consider it solved.
If you have any experience with VBA, or are interested in learning, this would be fairly simple with VBA.
Dare I ask what “ERP” stands for? I know of one thing that acronym can mean, but it doesn’t usually involve a “system”, nor “generating reports”. At least, I think it doesn’t.
“Erotic roleplay”. Although I rather doubt it means that in this context. ![]()
In this case, I assume it’s “Enterprise Resource Planning”.