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 split into two different columns.  In some cases the first name does not show up in the second column.  I do not want the first and last name splinto into two columns I wanted them converted into one column like it is in the PDF file.  Is there a setting somewhere I need to adjust?  Any one know why in some cases the first name is dropped completely?  Thanks in advance for in solutions.

Need Help

5 Replies

  • 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)