Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power query import from PDF

I have a PDF file with five columns.  One of the columns has individuals names in it with a format of lastname, firstname.  However, when I try to transform the data the first and last names are spli...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

are there commas involved?

 

Can you post a sample PDF that illustrates the issue?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    There are commas in the username column of the PDF separating the last and first name.

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      You would need to import the data without separator and then in Power Query split the text as needed  (via "first occurence"  for example)

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Thank you.  How do I import a PDF file without the separator?  Is there a setting in Power Query that I need to change to turn off the comma separator?