5 Replies Latest reply: May 11, 2013 8:57 PM by Yellowbox
prichar Level 1 Level 1 (0 points)

Exporting a credit card statement.  In numbers I would like to create columns with the info through parsing.  thanks phil


iPad 2, iOS 5.1
  • 1. Re: can you parse a document?
    Barry Level 7 Level 7 (29,180 points)

    What format is the exported document file?

     

    On what will Numbers base the parsing of this document?

     

    Regards,

    Barry

  • 2. Re: can you parse a document?
    prichar Level 1 Level 1 (0 points)

    Copying a statement from the web creates a string of info with no delineation.  Would like to bring the PDF doc info into individual info columns.  Excel use to have a parse function that one could replicate a string into a column format.  Does that help?

  • 3. Re: can you parse a document?
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Prichar,

     

    Numbers has no feature that will help you to import a PDF into a table. I've heard that MS offers a trial version of Excel. Why not give that a try. Let us know how it works out.

     

    Jerry

  • 4. Re: can you parse a document?
    Wayne Contello Level 6 Level 6 (13,620 points)

    you can open a PDF document in a program called Skim and generally you can select data in a table, copy, then paste into a table in Numbers-- sometimes you have to hold the option key down while selecting tablular data.

  • 5. Re: can you parse a document?
    Yellowbox Level 5 Level 5 (4,580 points)

    Hi prichar,

     

    Copying a statement from the web creates a string of info with no delineation

     

    Are you copying by selecting then Copy (command v)?

     

    If this is a bank statement, can you instead download a comma separated values (csv) file? My bank allows various formats for downloading statements, and csv will open in Numbers. The commas delineate columns.

     

    Regards,

    Ian.