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_Rediscover_Stor
age1_042009
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
