What is your go to method for cleaning messy PDF data imports

I have to pull data from PDF reports pretty often and it always seems to come in with random line breaks, weird spacing, or numbers formatted as text. Im curious what everyones preferred workflow is for this. Do you rely on Power Query's PDF connector, paste it in and use Text to Columns, or have you built a VBA macro to handle the cleanup. Just looking for some fresh ideas because my current method feels like it takes way too long.