Use return carriage in the position function.

[Capt JB]

I have plenty of texts I want to enter in a database.

Each text have basically a first line which is the title of the document. 

I tried to have the entire first line automatically pasted into the title field using a script with find, copy, paste...

But I have no idea on how to tell FMP to copy everything in the first line before the return carriage which is the only common character to specify the end of the line...

How to to tell FMP to use all 'special' characters that are in a text field ?? (letters, and space being the easiest), but carriage return, tab, etc...

 

There too, I am close to excess of aspirin..!

 

Thanks for any tip or lead

 

[Raybaudi]

GetValue ( YourText ; 1 ) returns only the title of your document

[Lee Smith]

Automatic message

This topic has been moved from "Conditional Formatting" to "Calculation Engine (Define Fields)".

[IdealData]

The 'carriage return' character is "¶". It is part of the 'special' characters in the calculation dialog box.

 

Other non-printing characters can be held in global fields in your database and you can initialise them by typing the character into the field.

From there on you can reference the global fields in the calculation dialog box.

[Capt JB]

Thanks a lot guys, one headache less