Hi,

I'm attempting to Parse out a Price List which was sent to me on a Pdf Format.

I know some of you are just as fond as me with these parsing scripts and techniques, so I would be grateful of any help you could provide.

I'm wondering which of FM7 new text tools you'd be using here.

Attached is a sampler of the pdf document (70 pages in the final one), and below is part of the text returned from a first copy/paste to a global field.

Text Copied :

AGORA

PriceList.pdf

Ok,

I feel like I may ask too much, so here's something that just could be sufficient for me, and which I couldn't find my way through.

1.429,04 90X90D MOS HERM. R90N MOSAICO ROSONE ANTICATO PZ 1 0,81 18 1 22,22 0,81

1.368,09 MOS POSE. R90N

1.327,29 MOS EOLO R90N

1.429,04 90X90D MOS HERM. R90L MOSAICO ROSONE LUCIDATO PZ 1 0,81 18 1 22,22 0,81

What determines a Product Description *break* are the 6 last numbers of the first line and the 6 last numbers of the last one.

So that if the end of a line in my text field has 6 numbers separated with spaces, it should account for a default list of numbers that should be reported to the lines in between the 2 *breaks*.

How can you determine that a field (when each line is converted to a gExtractionField in my loop) has x numbers at the end :

Is that clear ?

This was given off list by Queue...

Length( Filter( Right( field; Length(field) - Position( field; " "; 0; PatternCount( field; " " ) - 5 )); "0123456789," ) ) = Length( Substitute( Right( field; Length(field) - Position( field; " "; 0; PatternCount( field; " " ) - 5 )); " "; "" )) AND Length( Filter( Right( field; Length(field) - Position( field; " "; 0; PatternCount( field; " " ) - 6 )); "0123456789," ) )

Thank you Queue.