Hi.



My document contains running notes (paragraphs) and tables which are replicated from an original PDF. After converting from PDF to word some tables are not translated in table format even though it is in tabular format in original PDF and this information was converting as a paragraph and this information need to be search and keep it in a tabular format.

This information is searched page-by-page in a document, which takes more time due to the large number of pages (250+).

Would it be possible to automate this task as a paragraph with numbers (123,234,98) or a line with numbers should be tagged as ## at the table enter mark (¶) beginning or ending or at the beginning of the lines or at the beginning of the paragraph with values.

Since I am a beginner, please forgive me if it seems impossible.

It would be appreciated greatly if you could help me with this. I am always grateful for your assistance.

Ex: Input file(Before running a macro)

Within six months 2,745,109 13,727 0.5% 2,329,021 11,636 0.5%
Six months to one year 41,208 2,060 5% 34,142 1,707 5%

One to two years 5,092 1,527 30% 10,725 3,217 30%

Two to three years 3,571 1,785 50% 2,323 1,161 50%

Three to four years 302 302 100% 434 434 100%

Four to five years - - - 413 413 100%

EX: Output file (After running a macro)

##Within six months 2,745,109 13,727 0.5% 2,329,021 11,636 0.5%
##Six months to one year 41,208 2,060 5% 34,142 1,707 5%

##One to two years 5,092 1,527 30% 10,725 3,217 30%

##Two to three years 3,571 1,785 50% 2,323 1,161 50%

##Three to four years 302 302 100% 434 434 100%

##Four to five years - - - 413 413 100%

Hi,

Is there a possibility that we can resolve the above issue.

Please do the needful & Thank you....

You probably didn't get an answer because no-one understands exactly what it is that you want.

If you want to add ## to the start of every paragraph, do a find and replace
Find: ^p
Replace: ^p##

If your issue is in converting PDF to Word format, try different ways to convert the PDF. There are many different ways to convert PDFs to Word and each of these give different results, particularly around tabular information.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Hi,

Please accept my apologies for the inconvenience caused by the ambiguity in the above thread.

The document contains specific text with values that I would like to extract.

Ex: String “Alpha” is presented 230 time in a document Such as “Alpha” followed by running text presented 225 times & “Alpha” followed by the values presented 5 times. I want to extract “Alpha” with values only.

Searching “Alpha” will take more time over the document and having a chance of skipping the value.

Would it be possible to have a macro that tags "Alpha" with only values (“0-9”, “ ,” “-”, “.”)

Simply to tag specify text having only values or " “– " (Null values) or to tag specific text followed by other than Alphabets I.e. (“0-9”, “ ,” “-”, “.”)

Ex 1:

Input:

Alpha 325,073,525.57 168,023,239.06 4,299,873.55 152,750,412.96
Alpha -- 32,992,309.96 -- 36.70% 2,856,936.33
Alpha 137,469,744.75 130,686,669.60

Output:

@@Alpha 325,073,525.57 168,023,239.06 4,299,873.55 152,750,412.96
@@Apha -- 32,992,309.96 -- 36.70% 2,856,936.33
@@Alpha 137,469,744.75 130,686,669.60

Ex 2:
In the below paragraph string “Alpha” shouldn’t get tagged because the text “Alpha” doesn’t having any value.

The data of “Alpha”, indigo and XN software packages (1) in the report
From the chart it (2) that “Alpha” (3) the highest annual saving. However, the
training cost of this software (4) the highest among all the three software packages.
Purchase price of XN (5) the highest though its savings __ (6) lower than “Alpha”.

It would be greatly appreciated if you could assist me in this regard.

Use a find and replace with wildcards turned on
Find: Alpha [0-9, ^45]{5,}
Replace with: @@^&

This will find the word Alpha followed by at least five characters that you specified (numbers comma space or hyphen)

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia