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

Parsing from long string of numbers

samshem
in Calculation Engine (Define Fields)

Featured Replies

Does somebody know how I could parse a 12 digit number that starts 16 digits in and ends 4 digits before the end? For example the string of numbers 9761243631002561 724686727627 2019, the numbers that are in the middle are the ones that need to be parsed from the entire string. How would I specify that in a calculation? Thanks for the help.

If there will always be a space before and after the string you wish to extract, you can use this:

MiddleWords ( theField ; 2 ; 1 )

Use the Middle ( text ; start ; numberOfCharacters ) and fill in the blanks

i.e.

Middle ( YourField ; 16 ; 12 )

  • Author

Thank you again for your assistance, it works.

Create an account or sign in to comment

https://fmforums.com/topic/49567-parsing-from-long-string-of-numbers/
Go to topic listing

Important Information

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

I accept

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.