I Didn't really want to do that. I opted for the &COMO& solution, then used the editor to delete out all the TOF's, then saved what was left in &SAVEDLISTS&. At that point I did a GET.LIST, followed by a SELECT on the file that the ID's were to point to. This weeded out all of the blank lines that the editor was not able to remove.
Moving over to Excel and deleting columns would have been choice #2 George > -----Original Message----- > From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- > us...@listserver.u2ug.org] On Behalf Of Ron Hutchings > Sent: Wednesday, April 01, 2009 10:30 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] SQL a possibility? > > If you can move between your PC and the server. Open the spreadsheet, > delete > all the columns you don't want, save the one column as a text file, > move the > file back to the server in &SAVEDLISTS& and you have created a list. > > > > From: ggal...@wyanokegroup.com > > To: u2-users@listserver.u2ug.org > > Date: Wed, 1 Apr 2009 16:21:28 -0500 > > Subject: [U2] SQL a possibility? > > > > I'm trying to save the first field of a .csv file to a select list, > Yes, I > can > > write a program, > > but I also wanted to try to do it on the fly. > > > > Using UV10.0.2 , unix on Information format > > > > The source data looks like: > > '#12345566#','first','last',..... > > '#12344555#','first','last',..... > > > > Basically, field one has the item ID of another file. > > > > The source file gets read into a tempory file input file > > > > I created an I-desc of the following: > > > > SWITCHIT > > 0001: I > > 0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ; > FIELDS(@1,REUSE(","),REUSE(1)) > > ; > > CONVERT(REUSE('"# '),REUSE(''),@2) > > 0003: > > 0004: DATA > > 0005: 20L > > 0006: M > > > > The above will convert the whole record into one mutlivalue > attribute, > > then strip off the first field delimited by the "," > > then strip out the # ,' and spaces > > > > LIST FILENAME ITEMNAME SWITCHIT ID-SUPP will list to the screen > exactly > what > > I want > > and so does > > SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME'; > > > > Now....How can I put that data into a saved-list? (Using either TCL > or > SQL?) > > for that matter, how do you save a list using SQL on Universe? I > tried > > creating a view, but was told I > > had to create a schema in order to create tables...that's no > fun... > > > > I could open a como file, list the output with no headings close the > como > > file, > > edit it clean, the form-list the como file (work around 1) > > > > George > > ------- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > > _________________________________________________________________ > Rediscover Hotmail.: Get e-mail storage that grows with you. > http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscove > r_Stor > age1_042009 > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
