[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
unstring with Tab delimiter
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!!