Jump 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.

I have a number field (id_witness) containing a list of 3-digit numbers separated by returns. I want to append a decimal point and a four-digit number to each 3-digit number of the existing list of numbers to another field (id_Qs). How can I do this?

Featured Replies

  • Newbies

In other words, I want to convert (id_witness):

518
501
500
518
504
534
544
556
547.1799

to (id_Qs):

518.1799
501.1799
500.1799
518.1799
504.1799
534.1799
544.1799
556.1799
547.1799

First of all, a return-separated list of numbers is not a number, and the correct type of field to hold such list is Text. Filemaker is pretty tolerant when it comes to field types (and data types in general) but you may run into unexpected consequences of such mismatch.

Now, assuming that the return-separated list does not have a trailing return, you could do the required conversion quite simply as:

Substitute ( id_witness ; ¶ ;  ".1799¶" ) & ".1799"

(I am also assuming that the "547.1799" entry in the source list is actually "547".)

 

  • Author
  • Newbies

Thank you sooooo much!

Create an account or sign in to comment

Important Information

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

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.