Single quote delimiter in parsing

rohitsir · New User Joined: 21 Aug 2007 Posts: 32 Location: USA

I have a string:
DEFINE SBR NAME='SC#HOG',

I want to parse the string data such that I get SC#HOG in a separate field without quotes. Can I do this just using single PARSE VAR instruction ???

superk

Does this work for you?

string = "DEFINE SBR NAME='SC#HOG',"
...
Parse Var string . "'" varname "'" .

or

Parse Var string . '=' varname ',' .
varname = Strip(varname,B,"'")

rohitsir · New User Joined: 21 Aug 2007 Posts: 32 Location: USA

The first approach doesn't work. I have already tried it. The second approach does work. I have done sth different to achieve it.

LEN = LENGTH(VARNAME)
VARNAME = LEFT(VARNAME,LEN - 1)
VARNAME = RIGHT(VARNAME,LEN - 2)

Thanks for the reply.

superk · Posted: Fri Mar 14, 2008 11:29 pm Post subject:

rohitsir · New User Joined: 21 Aug 2007 Posts: 32 Location: USA

My bad. It does work.