Power query import from PDF

[Anonymous]

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.

[lbendlin]

are there commas involved?

Can you post a sample PDF that illustrates the issue?

[Anonymous]

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

[lbendlin]

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]

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?

[lbendlin]

Can you post a sample PDF?