Re: Simplest way to turn an excel column into a savedlist

Hi Dawn
The quick and dirty way is as follows
In Excel
Select the column that you want with the mouse
Edit > Copy
Open Notepad
Edit > Paste
Save the NotePad item say as test.txt
Then Copy it into your Pointer File
In D3 (sorry I don't have U2 to play with)
COPY DOS:D:/ TEST.TXT
to:(POINTER-FILE) FOO
GET-LIST FOO

Normally using Hostaccess or Accuterm I would skip the copy to notepad part. Just ED an item, enter I for input then paste. I often do this with sample progs from this list for example but the copy from Excel chokes after the first cell.
Peter McMurray

"dawn" <dawnwolthuis@xxxxxxxxx> wrote in message news:80f7fadd-3413-47cc-b2a8-c1032d1b99b1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
This might be a really stupid question (feel free to add that to the
front of any of my questions)--

If an end-user has an Excel spreadsheet open with a column in it with
the values of a file @ID and they want that list of values to turn
into a savedlist they can use in U2, for example, what is the simplest
way for them to get there?

Assume that they are using a proprietary GUI to run their application
with no option to switch to another proprietary terminal emulator, but
that they have some access to the column prompt. [Although if there is
a tool that does this, even if a term emulator, I would be interested
in knowing what it is]

Maybe this is an ftp wrapper of some sort that also handles putting
csv data into a savedlist, or maybe for small enough volume there is a
cut-and-paste approach that would be easy enough to teach someone,
or ...?

If you were to write a little utility to make this easy, what would
you do?

TIA. --dawn



.

Relevant Pages

  • Re: news.individual.net problem on plusnet?
    ... I get the error message; ... I was trying to edit it by opening in notepad but it seems that I ... Login to a user with administrator privs. ...
    (uk.telecom.broadband)
  • Re: POP UP when trying to edit Stationery files on OE
    ... Notepad like i wanted it too....this is too strange!!... ... POP UP when trying to edit Stationery files on OE ... For over a year i have been able to edit stationery files using Notepad ... I have even gone as far as selecting "choose another program" and then ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: installing os to 2nd hard drive
    ... Now to get the pesky errors fixed at startup. ... but I can edit my boot.ini file. ... Settings, in the System Startup panel clk Edit, and that will ... allow you to edit the boot.ini file using Notepad. ...
    (microsoft.public.windowsxp.setup_deployment)
  • Re: Using Internet Explorer? Heres how to improve its security against Aurora attacks.
    ... If you're running Windows XP with Service Pack 2, ... In the System startup field, click Edit. ... In Notepad, click Find on the Edit menu. ... type attrib -s -h boot.ini to remove the system and hidden ...
    (alt.2600)