Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Use return carriage in the position function.

Capt JB
in Calculation Engine (Define Fields)

Featured Replies

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

 

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

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.

  • Author

Thanks a lot guys, one headache less

Create an account or sign in to comment
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.