tvdl

I am trying to use Substitute to replace "-signs in a text by nothing. But FM does not accept a formula like Substitute (Text; """"; "") Is there another way to remove " signs from a field via a calculation? Ton

Thanks for you help. It works perfectly now! Ton

Thanks for you reply. I tried that, with all the different options. But it doesn't work. In my layout I have made room for three pages. The text field is also three pages long in the layout. But if the text is very short, and does not exceed the first page, still all the three pages, of which two are empty, will be printed. Ton

I am trying to make up a script to print records containing one field with a very large text. The length of this text varies per record from one line to a few hundred lines. The problem is that if I design a layout that would for instance be three pages long (for about 180 lines), the printer would print three pages per record, whether the text in the field is only a few lines, or very many lines. I the first case I am left with empty pages. Is there a way to instruct the printer to only print the first pages with text in it?

I am trying to find a way to find a string in a very long text field. In my database with notes, one of the fields contains the text of the notes. These are sometimes very long texts. If I search for a word in the this field, of course I get al the notes with this word in it. Only, how do I find that word within the field? Maybe there is a way to move the cursor to a specific location within a field?