Jump to content

Middle letters? Possible?


This topic is 2381 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi All,

 

I'm familiar with the middle words function but I'm looking to separate individual letters. I have a table with values the first 2 letters of which I do not need. I'm looking to create a field or function that skips the first 2 letters and displays everything after the first 2 letters.

Is this possible or is the middle words the only way?

Link to comment
Share on other sites

Then you want the Middle function. I think that Comment provided exactly the answer you wanted recently here. But maybe that was somebody else; or over in a different forum.

Anyway:

https://fmhelp.filemaker.com/help/16/fmp/en/#page/FMP_Help%2Fmiddle.html

Middle
 
Purpose 
Extracts the specified numberOfCharacters from text, starting at the specified character position.
Format 
Middle(text; start; numberOfCharacters)
Link to comment
Share on other sites

This topic is 2381 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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