Another reading character from string and extracting portion of string 3

[mwmark]

I am trying to look at a string and find a character ("s" in this sample), then display the remaining text after the "s".

Sample data:
2857516MAS75330
3057016MAS75333
2253519MAS4472017

Desires result:
75330
75333
4472017

I tried using the thread "reading character from string and extracting portion of string" but didnt have any luck with the examples given.

 

[synapsevampire]

Try:

whileprintingrecords;
stringvar S := {table.field}
If ubound(split(s,"S")) = 2 then
split(s,"S")[2]
else
"N/A"

-k

 

[synapsevampire]

Forgot a semicolon:

whileprintingrecords;
stringvar S := {table.field};
If ubound(split(s,"S")) = 2 then
split(s,"S")[2]
else
"N/A"

-k

 

[dgillz]

mid({YourField},instr({YourField},"S")+1) should work, but it may have 2 problems:

1) If there is no "S" it will return the entire string.
2) If there is more than one "S" it will return everything after the first "S".

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[RustyAfro]

Synapse,

Thanks, that helped me with something non-related. Here's a star!

Joel