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.

Trimming text

chevell
in Calculation Engine (Define Fields)

Featured Replies

I have a text string that is a file location. Its something like X:usersfreddocuments, or W:filesgeorgeshared.

I want to extract the user name from the middle of that. The user names are all different lengths, and the locations are all different, so i can't use an exact length right/left function. I need to basically filter everything before the second slash and after the third.

Any ideas.

Middle (

yourtext;

Position ( yourtext; "" ; 1 ; 2 ) +1 ;

Position ( yourtext; "" ; 1 ; 3 ) - Position ( yourtext; "" ; 1 ; 2 ) - 1

)

But I realized that this only works if the location is similiar, with a patterncount you could make it a bit more precise but not all the way....

  • Author

The calculation does not appear to like the "". Its asking for another operator.

Not sure how I would apply patterncount to this. Could you elaborate? Thanks!

The calculation works in v6, in order for it to work in v7, you have to escape the "", with a second

this amended calculation works for the examples given.

Middle( text;

Position( text ; "" ; 1 ; 2 ) +1;

Position( text ; "" ; 1 ; 3 ) -

Position( text ; "" ; 1 ; 2 ) -1

)

Lee

cool.gif

MiddleWords(Substitute(Text; ""; " ");3;1) also works.

edit: Though in the above spaces in a folder name would throw off the calculation.

Substitute(MiddleValues(Substitute(Text; "";

  • Author

Awesome, that works! Thanks!

Create an account or sign in to comment

https://fmforums.com/topic/33698-trimming-text/
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.