Re: unstring with Tab delimiter

[Ray Ontko <rayo@ONTKO.COM>]

Kimberly,

> Bear with me folks.  I'm kind of new to SQR.
>
> I'm trying to unstring data that uses Tab as it's delimiter.  (The data
> originally came from Excel so I don't have much choice about the
> delimiter).  I can't seem to figure out the exact syntax to put a tab in
> the delimiter with the unstring command.  I've tried actually typing a tab
> between quotes and without quotes.  I've also tried [Tab] and {Tab} both
> with and without quotes with no luck.  I'm using Informix which uses '\t'
> and I've tried that too but that didn't work either.
>
> If anyone has done this before I would love to hear how you got it to work.
> I'm sure it's something pretty simple but I've gone through my book and
> used all the resources I have available to me and have come up empty
> handed.
>
> Thanks in advance for your help!!

Try this:

   ENCODE '<9>' INTO $tab

or this:

   LET $tab = chr(9)

Then you should be able to do this:

   UNSTRING $my_string BY $tab INTO $p1 $p2 $p3 $p4

Ray

P.S. Welcome to SQR land!
----------------------------------------------------------------------
Ray Ontko       |  Ray Ontko & Co  |  "Ask me about SQR and the web.
rayo@ontko.com  |  Richmond, In    |  See us at http://www.ontko.com/