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

Re: Unstringing characters



you need to make sure that the delimiting character
cannot appear in the first field.
Then you can use instr function find the position of
the delimiter and use the substr function to get the
field you are looking for.

hope this helps
Arun
--- 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