Home > Forum Home > Developing Business Administration Solutions > Importing Data from PDF Files > importing a number and not the percent symbol Share

Importing a number and not the percent symbol

Excel Help for Importing A Number And Not The Percent Symbol in Developing Business Administration Solutions


Forum TopicLogin

Importing A Number And Not The Percent Symbol

Rate this:
(4/5 from 2 votes)
Confused Hi
Thanks a lot for this great tool. it works like a charm.
Only one thing I am not having any luck with. I have a number displayed as a percentage in the pdf document and I only want to import the number as is, but not the percentage symbol. I would appreciate any help on how to do this.

Here is an example:

in the pdf I have this line:
Making up a number 0.5 %   10.0 %

I used the following to import the numbers:
Start Text     End Text      Replacement Pairs
number        %*              number,|%

When I 'Run Extraction' I get the following output:
0.5      10.0

so my question is how do I get the program to only return the number 0.5 and not the 10.0

Thanks
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for importing a number and not the percent symbol in the