Multiple Values

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic


   When I extract the text from a pdf, I get 4 multiple values.  I think the report has been created from an access database.  Here is the Sample of the output.  Thanks
174.96,701.88,#000000,10.98,"XTSEBN+TimesNewRoman,Bold","ABC San Jose, CA" 174.96,688.8,#000000,8.99,"XTSEBN+TimesNewRoman,Bold","1514 Moffett St. Suite" 174.96,678.12,#000000,8.99,"XTSEBN+TimesNewRoman,Bold","San Jose, CA 93905" 68.52,587.76,#000000,11.98,"XTSEBN+TimesNewRoman,Bold","ABCD Company" 111.48,524.28,#000000,11.98,"UGLJTT+TimesNewRoman","(408) 123-4567" 111.24,524.04,#000000,11.98,"UGLJTT+TimesNewRoman","(408) 123-4567" 111.48,524.04,#000000,11.98,"UGLJTT+TimesNewRoman","(408) 123-4567" 111.24,524.28,#000000,11.98,"UGLJTT+TimesNewRoman","(408) 123-4567" 68.52,555.72,#000000,11.98,"UGLJTT+TimesNewRoman","123 S. 1st Street" 68.52,540,#000000,11.98,"UGLJTT+TimesNewRoman","Gilroy, CA 93930" 69.48,571.92,#000000,11.98,"UGLJTT+TimesNewRoman","Jose Rodriguez" 69.24,571.68,#000000,11.98,"UGLJTT+TimesNewRoman","Jose Rodriguez" 69.48,571.68,#000000,11.98,"UGLJTT+TimesNewRoman","Jose Rodriguez" 69.24,571.92,#000000,11.98,"UGLJTT+TimesNewRoman","Jose Rodriguez"

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
pmariottini Members Profile Find Members Posts Beginner Joined: 27 Sep 11 Status: Offline Points: 2	Post Options Post Reply Quote pmariottini Report Post Thanks(0) Quote Reply Topic: Multiple Values Posted: 27 Sep 11 at 6:05PM
	When I extract the text from a pdf, I get 4 multiple values. I think the report has been created from an access database. Here is the Sample of the output. Thanks 174.96,701.88,#000000,10.98,"XTSEBN+TimesNewRoman,Bold","ABC San Jose, CA" 174.96,688.8,#000000,8.99,"XTSEBN+TimesNewRoman,Bold","1514 Moffett St. Suite" 174.96,678.12,#000000,8.99,"XTSEBN+TimesNewRoman,Bold","San Jose, CA 93905" 68.52,587.76,#000000,11.98,"XTSEBN+TimesNewRoman,Bold","ABCD Company" 111.48,524.28,#000000,11.98,"UGLJTT+TimesNewRoman","(408) 123-4567" 111.24,524.04,#000000,11.98,"UGLJTT+TimesNewRoman","(408) 123-4567" 111.48,524.04,#000000,11.98,"UGLJTT+TimesNewRoman","(408) 123-4567" 111.24,524.28,#000000,11.98,"UGLJTT+TimesNewRoman","(408) 123-4567" 68.52,555.72,#000000,11.98,"UGLJTT+TimesNewRoman","123 S. 1st Street" 68.52,540,#000000,11.98,"UGLJTT+TimesNewRoman","Gilroy, CA 93930" 69.48,571.92,#000000,11.98,"UGLJTT+TimesNewRoman","Jose Rodriguez" 69.24,571.68,#000000,11.98,"UGLJTT+TimesNewRoman","Jose Rodriguez" 69.48,571.68,#000000,11.98,"UGLJTT+TimesNewRoman","Jose Rodriguez" 69.24,571.92,#000000,11.98,"UGLJTT+TimesNewRoman","Jose Rodriguez"

Wheeley Members Profile Find Members Posts Senior Member Joined: 30 Oct 05 Location: United States Status: Offline Points: 146	Post Options Post Reply Quote Wheeley Report Post Thanks(0) Quote Reply Posted: 27 Sep 11 at 10:26PM
	Don't take this the wrong way, but: What are you trying to ask? You have no question in your post. Wheeley

AndrewC Members Profile Find Members Posts Moderator Group Joined: 08 Dec 10 Location: Geelong, Aust Status: Offline Points: 841	Post Options Post Reply Quote AndrewC Report Post Thanks(0) Quote Reply Posted: 28 Sep 11 at 3:15AM
	Some PDF libraries draw overlapping text objects a few pixels apart to simulate BOLD font drawing using the a normal font. Looking at the coordinates in your file this is exactly what is happening. So technically there are four different text strings in the PDF which QPL is extracting correctly. Notice the very minor offsets in the x,y positions for the repeated text. 111.48,524.28,#000000,11.98,"UGLJTT+TimesNewRoman","(408) 123-4567" 111.24,524.04,#000000,11.98,"UGLJTT+TimesNewRoman","(408) 123-4567" 111.48,524.04,#000000,11.98,"UGLJTT+TimesNewRoman","(408) 123-4567" 111.24,524.28,#000000,11.98,"UGLJTT+TimesNewRoman","(408) 123-4567" 68.52,555.72,#000000,11.98,"UGLJTT+TimesNewRoman","123 S. 1st Street" 68.52,540,#000000,11.98,"UGLJTT+TimesNewRoman","Gilroy, CA 93930" 69.48,571.92,#000000,11.98,"UGLJTT+TimesNewRoman","Jose Rodriguez" 69.24,571.68,#000000,11.98,"UGLJTT+TimesNewRoman","Jose Rodriguez" 69.48,571.68,#000000,11.98,"UGLJTT+TimesNewRoman","Jose Rodriguez" 69.24,571.92,#000000,11.98,"UGLJTT+TimesNewRoman","Jose Rodriguez"

pmariottini Members Profile Find Members Posts Beginner Joined: 27 Sep 11 Status: Offline Points: 2	Post Options Post Reply Quote pmariottini Report Post Thanks(0) Quote Reply Posted: 28 Sep 11 at 11:58PM
	I apologize, I copied the question from a word document and I guess I left out the question part. My question was, Are there any useful functions for dealing with repetitive values? Thanks