Formula to remove anything before the space in the field 1

[jeffm777]

Have a field with the following value...

ACURA LEGEND

I want to remove ACURA and the space before the word LEGEND so the formula returns only LEGEND.

I know how to get just ACURA...

if {Inventory.Model} startsWith 'ACURA' then left ({Inventory.Model},6) else {Inventory.Model}

but can't figure out who to get just the LEGEND.

 

[cyreports]

Wouldn't you just use the RIGHT versus the LEFT to Get LEGEND? Not a pro but seems right. Give that a try and let us know.

 

[jeffm777]

Seems logical but the provided data was only an example...there's no way to tell how many characters will actually be after the word ACURA.

 

[jeffm777]

Got it...

if {Inventory.Model} startsWith 'ACURA' then Split ({Inventory.Model}, " ") [ 2 ] else
{Inventory.Model}

 

[N22S]

The following should also work:

right({string.field},((length({string.field})) - (instr({string.field}," "))))

Note that the instr will find the first blank field, not subsequent ones. Also, if the data could possibly be entered with a blank before ACURA, this will be an issue as well.

 

[jeffm777]

Hi N22S. Thanks for the post. That works very well. The only issue I'm going to run into is on a model such as SANTE FE, it only returns FE so I'm going to build some logic into the formula to account for these.

Tks again!