2 Replies Latest reply: Oct 15, 2014 9:16 PM by Charlie Cooper RSS

    varying lines and odd data pattern

    Charlie Cooper


      Sorry, I've been reading through the forum and coming across similar questions about variation in lines from an imported PDF report but I'm still stuck.


      I've imported a PDF contact list and I can't find a pattern to focus on for an Append template.


      I've pasted a sample below (apologies...it's pretty terrible):                                                                                                                                                 

      BlueScope           Client               IT             Enterprise        Peter                            Application     

      Steel Limited                                                                                                             Portfolio       



      Bunnings              Prospect                          Enterprise        Peter                           Group           

      Group Ltd                                                                                                                 Financial       

                                                                                                                                       Planning &      




      Deloitte                 Partner                                                     Peter                          Senior          

                                                                                                                                       Partner -       





      IBM Australia        Partner          Sales &                               Peter                         BA Sales        

      Limited                                       Marketing                                                              Specialist


      Basically - 6 columns which can be blank - least number of rows for a contact is 2, most is 6...and there doesn't seem to be anything common except for a completely blank row between contacts.


      Please help!!!


      Thanks in advance!

        • Re: varying lines and odd data pattern
          Olly Bond

          Hello Charlie,


          You might find the Invisible Data webcast helpful. Or you could try throwing the PDF at some Experts and asking for a model on the next working day. There's a reasonable fee for the service - equivalent to the charge for attending a two day Modeler training course. But it's likely that you'll learn as much from seeing the model that solves the problem as you would attending the course, so we think it's fair.


          Best wishes,


          • Re: varying lines and odd data pattern
            Charlie Cooper

            Hi Olly,

            Thanks for the quick response.  I watched the Webcast and it was a great help.  Managed to get it working within 30 mins of watching the video.