[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Unstringing characters



Try this,

let $s = 'Employee/1728347'
let $id = substr($s,instr($s,'/',1)+1,length($s))
show $s
show $id

Jim

--- Erik Siradas <erik_siradas@HOTMAIL.COM> wrote:
> Hey All!!
>
> I have a problem that hopefuly someone can help me with.  I have to
> unstring
> a field, breaking at a character.  This is what I mean. I have a
> field
> cominging in as 'Employee/1728347'.  I need to draw the number after
> the '/'
> to a report.  The character length before the '/' is always going to
> be
> different so I need something that will go through the string and get
> all
> characters after the '/'.  Thanks
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com


__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com