cancel
Showing results for 
Search instead for 
Did you mean: 

Search

Former Member
0 Kudos

I am trying to make a formula that will pull out a part of a part description.

An example would be.... I want to display only the word SNA from this string field result........ MTR COMB SP 08 SNA

Sorry all, I have tried searching the Help files but I did not know what this function is called, to do this.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

What are the criteria when you want to show a part of that string field? Will it always be the last 3 letters?

If so, you can do a simple formula like:

Right({field.name}, 3)

This will return only the last 3 letters of the field name you specify.

Former Member
0 Kudos

Does it have to be a formula, if you use the Select Expert and choose the field and use the 'Is Like' option, you can then wildcard the feild using * to search for it where ever it is in the string, like this 'SAN',

Edited by: Jeff Westcott on Jul 16, 2008 4:37 PM

Edited by: Jeff Westcott on Jul 16, 2008 4:38 PM

Former Member
0 Kudos

IF "sna" in LOWERCASE () then "SNA" else ""

Former Member
0 Kudos

Once again Crystalier you have solved the issue. Thank You very much!!!

Answers (0)