Tracy,
I do not remember what version of Suprtool you have but if you are on
4.7.02 or later you can use the $split function to separate out the fields
and then do and update. For more information on the $split function, please
see the following page on our website:
http://www.robelle.com/tips/suprtool.html
and scroll down to the heading "Splitting Byte Fields".
Hope this helps,
Barry
On 24 Apr 2004 Tracy Pierce <[log in to unmask]> wrote
Date sent: Sat, 24 Apr 2004 11:47:55 -0700
From: Tracy Pierce <[log in to unmask]>
Send reply to: Tracy Pierce <[log in to unmask]>
To: [log in to unmask]
Subject: unpacking comma-delimited data?
> I need to unpack some typical comma-delimited data. I've written this in
> Cobol before, but can't find it grrr. Does anyone have a code snippet I can
> copy? Lazy, yes, but worth a shot!
> (data's similar to : "tracy",4159232266,"is lazy",-1.2345,"etc". Also due
> to laziness, Cobol's the only compiler I have on my 3000s.)
>
> Or there may be some long-overlooked Suprtool feature for this - output,link
> works great, STExport is great too, but I haven't noticed STImport or
> similar. ?
>
> btw while I'm on this topic, does anyone know how to force Excel to treat
> "12345" as a string? It annoyingly right-justifies these despite the
> quotes; mixed with "A12345" entries, it looks sloppy and is misleading.
>
> Thanks in advance!
>
> K Tracy Pierce
> Systems Programmer
> Golden Gate Bridge, Hwy & Transp District
> P.O. Box 9000 Presidio Station
> San Francisco CA 94129-0601
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
+------------------------------------------
+ Barry Durand [log in to unmask]
+ Allegro Consultants 408.252.2330 ext 223
+ http://www.allegro.com
+ Opinions are mine, not my employer's.
+------------------------------------------
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
