Bill Henry-
Brussel Sprout Connoisseur
If you are as frustrated with Don Mar’s (laughable) claim to be able to download all updated pricing from their web site and don’t wish to wait for months for a blurry, wrinkled photocopy of it in 6 point type, here is a down and dirty (if not particularly quick) way of getting it now.
Access the pages you want (Nielsen, in this case). You will be presented with a page that looks something like this.
Click on the right frame (the price side) of the page, “Select All” then “Copy”. Open a new Word Processing Document and “Paste” into it.
You will be left with a humongous sized price list (in blue of all things) which is barely usable.
But, if you show invisible and hidden characters,
you will notice that most of the fields are followed by a “return-tab-return” character sequence. The trick is to change those to a simple “tab”. Pull up the “Find/Replace” window and type in the following:
(for Word users, type in “^p^t^p” (the caret is Shift-6 for most keyboards, I think) in the <u>Find</u> box, and “^t” in the <u>Replace with</u> box. Choose “Replace All”.
This looks better, but each record has two carriage returns and, for readability, you’ll probably want only one.
Pull up the “Find/Replace” window and change the entries to the following:
(for Word users, type in “^p^p” in the <u>find</u> box, and “^p” in the <u>Replace with</u> box. Choose “Replace All”.
Once you do a “Replace All”, the word processing document will be a whole lot more readable.
Change the fonts and the sizing and the color to something you like, get rid of the invisible characters, and you’re good to go.
At this point, since this document is in a tab delimited format, it can be opened in a spreadsheet if you wish (at least, MS Office users can). AppleWorks users must first save this as a “TEXT” file (<u>NOT</u> the native AW word processing format). Once it is in a TEXT format, double clicking it will open it in an AppleWorks spreadsheet.
Just combine or append all of the documents you wish from Don Mar’s silly, user unfriendly tables and you’ve got something usable.
Access the pages you want (Nielsen, in this case). You will be presented with a page that looks something like this.

Click on the right frame (the price side) of the page, “Select All” then “Copy”. Open a new Word Processing Document and “Paste” into it.
You will be left with a humongous sized price list (in blue of all things) which is barely usable.

But, if you show invisible and hidden characters,

you will notice that most of the fields are followed by a “return-tab-return” character sequence. The trick is to change those to a simple “tab”. Pull up the “Find/Replace” window and type in the following:

(for Word users, type in “^p^t^p” (the caret is Shift-6 for most keyboards, I think) in the <u>Find</u> box, and “^t” in the <u>Replace with</u> box. Choose “Replace All”.
This looks better, but each record has two carriage returns and, for readability, you’ll probably want only one.
Pull up the “Find/Replace” window and change the entries to the following:

(for Word users, type in “^p^p” in the <u>find</u> box, and “^p” in the <u>Replace with</u> box. Choose “Replace All”.
Once you do a “Replace All”, the word processing document will be a whole lot more readable.

Change the fonts and the sizing and the color to something you like, get rid of the invisible characters, and you’re good to go.
At this point, since this document is in a tab delimited format, it can be opened in a spreadsheet if you wish (at least, MS Office users can). AppleWorks users must first save this as a “TEXT” file (<u>NOT</u> the native AW word processing format). Once it is in a TEXT format, double clicking it will open it in an AppleWorks spreadsheet.
Just combine or append all of the documents you wish from Don Mar’s silly, user unfriendly tables and you’ve got something usable.