Middle letters? Possible?

[wattmhite]

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?

[Lee Smith]

How about a Sample of the text?

14 minutes ago, wattmhite said:

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

 

[bruceR]

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)

[comment]

5 hours ago, wattmhite said:

function that skips the first 2 letters and displays everything after the first 2 letters.

Try =

Right ( Yourfield ; Length ( Yourfield ) - 2 )