Parsing last value in a string 3

[kskid]

Crystal 8.5
Oracle 8i using Oracle ODBC driver

Did a search for parse but came up empty for my situation.

I need to parse out the last word or letter in a string

Example

This is a test
Here we go
a b c e f g

Expected results

test
go
g

 

[bdreed35]

try this:

mid(rtrim({table.field}),InstrRev(rtrim({table.field}), " ")+1)

~Brian

 

[lbass]

Try:

mid({table.string},instrrev({table.string}," ")+1)

-LB

 

[lbass]

Almost simultaneous post, Brian, but not quite!

You could also use:

split({table.string}," ")[ubound(split({table.string}," "))]

-LB

 

[synapsevampire]

Or another fun means is:

split(trim({table.field})," ")[ubound(split(trim({table.field})," "))]

This allows for selecting any word by referencing it's position in the array index.

-k

 

[bdreed35]

Yeah, it was probably very close LB.

It would be nice if they put the time stamp on the post along with the date stamp.

Speaking of it would be nice's, are they ever going to fix the "My Info" page?

~Brian

 

[lbass]

Brian,

The My Info page is in the works and should be back soon, as far as I know...

-LB

 

[kskid]

Thank you all! A star for each of you

I figured it out in a round about way but it wasn't as elegant as all of you.

stringvar s:= strreverse({table.field});

if instr(s," ") = 0 then
{{table.field}}
else
right({table.field},instr(s," ")-1)

 

[synapsevampire]

Witchita: I think that yours looks great, the only potential gotcha is if the field is padded with spaces at the end, so adding a trim might help to ensure success.

-k