Jump to content

extracting middle chars from a string


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

Recommended Posts

i'm trying to extract the 3rd and 4th last characters from an 8-character string. for example, if the string is 12345678, i want to return 56.

i've worked around it by having an intermediate calc field Right (inputfield, 4) and then using a Left (intermediate, 2). but that's an extra field and feels clunky. seems to me it should be possible to directly access the required characters.

the input field always has 8 characters if that helps, and it's formatted as text, even though it contains numbers.

TIA.

FileMaker Version: 6

Link to comment
Share on other sites

This topic is 6497 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
 Share

×
×
  • Create New...

Important Information

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