[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