Hey all,
I have an interesting problem to try and solve with Power Automate, and after spending a few days digging into both the on-line flows and the desktop flows, I'm starting to think it cannot be done, so I wanted to reach out and see if anyone has advice.
Long story somewhat short, I need to take a poorly structured PDF file, pull out specific data, and then make a CSV with said data.
The problem is when parsing the PDF, it extracts as a single line, and I can't figure out how to break it apart logically so it can be placed into a CSV with proper formatting. Additionally, the .PDF file is poorly structured, and has bad data I do not want to pull.
Screenshot of the PDF is below:
This PDF structure cannot be changed, or altered, sadly. I need to pull the 'Username', 'Email', 'URL' and 'Password' field. The bolded 'Password' field at the top of each entry is actually the Title of the entry, in this old program, but it is labeled 'Password' in the export.
If I can pull that specific data, and not the bad password, I then need to convert the data into a CSV file for import into LastPass, using their template. Screenshot below and direct link here: https://support.lastpass.com/help/lastpass-sample-import-sheet
So far I can parse the PDF file, but it is only returning a single string, and I cannot split the data out of that string to then hopefully add to the CSV file. Any advice?
I know the AI Builder would probably be better for this, but we do not have the license for that and may not be able to purchase it.
Thanks in advance!
