Using RIGHT with INSTR

[jlclancy]

I am using this code to try and delete everything from the beginning bracket [ to the first semicolon. The memo field starts with the bracket and has several ';' however I only need to delete to the first semicolon. For example, the first pass shows a semicolon at 34; when I execute this code I get the last 34 characters, not the entire lenght except the first 34 characters...

stringVar str;
Str := {Police.Narrative};
Right(Str, InStr(Str, ";") -1))

Any suggestions?

thanks!

 

[jdemmi]

try this...


stringVar str;
Str := {police.narrative};
Mid(Str, InStr(Str, ";")+1)

just an fyi -- you don't NEED to create the variable to handle this.

-- Jason
"It's Just Ones and Zeros

 

[jlclancy]

I removed the variable and it worked, thank you.