Re: Shell output to Excel..

On Apr 9, 5:19 pm, Janis Papanagnou <Janis_Papanag...@xxxxxxxxxxx>
wrote:
Nikunj Khakhar wrote:
Hi,
I have created scripts for the snap caputring from the netapp
storage , currently i get output by mail (mail x) than i have to
monitor / capture some field and have to copy that field on the excel.
it is too bouring work so is there any script with I can directly
forwared the data to the exel file .

It's not clear what input data format you have and whether you just
want to put the data into a new exel sheet or insert it anywhere in
an existing table.

Generally you have the option to import CSV data into exel sheets.
Whether it is easy to achieve or not to convert your data to CSV
depends on how well the input data is structured. Post an example.

Janis





i dont have knowledge of the Oracle and sql .i am using solaris 10
os.

Your suggestion would be appricated ,thankx in advance.

Regards,
Nikunj- Hide quoted text -

- Show quoted text -

Thanks jennis,

Its ok with CSV also , i am having four column output so if any chance
i would export these all four column to execel (by generating csv) it
would better for me

so pl . suggest how to do it.......

regards,
nikunj

.

Relevant Pages

  • Re: Shell output to Excel..
    ... I have created scripts for the snap caputring from the netapp ... want to put the data into a new exel sheet or insert it anywhere in ... Generally you have the option to import CSV data into exel sheets. ... In the interests of making progress, lets assume your data is tab-separated and each field cannot contain any tabs so all you want to do is wrap each field in double quotes and change the separator from a tab to a comma. ...
    (comp.unix.shell)
  • Re: [CFR][CFT] counter(9): new API for faster and raceless counters
    ... The only problem we have is that every user land tool has its own format, ... The idea of outputting xml is good, CSV is OK, however CSV is problematic as ... I should be able to share our scripts within the next couple of days. ... It'd be really nice if we could come up with a consistent statistics ...
    (freebsd-arch)
  • Re: Using a CSV file to Bulk Modify users in AD! HEEELP!
    ... it will do CSV based updates. ... I have often used VB scripts, LDIFDE scripts and CSVDE to automate various tasks in AD. ... I have been supplied with a CSV spreadsheet containing data about all the companie's users that have to be imported into AD. ... I have been battling trying to work out how to use this CSV file in a script to rapidly modify all my 4000+ users, who thankfully will be in one OU. ...
    (microsoft.public.win2000.active_directory)
  • Re: Script a Bulk Modification of ALL AD users?
    ... I responded to this in another newsgroup, but AdMod will do CSV updates, read the /csv? ... I have often used VB scripts, LDIFDE scripts and CSVDE to automate various tasks in AD. ... I have been supplied with a CSV spreadsheet containing data about all the companie's users that have to be imported into AD. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Shell output to Excel..
    ... I have created scripts for the snap caputring from the netapp ... storage, currently i get output by mail than i have to ... want to put the data into a new exel sheet or insert it anywhere in ... Generally you have the option to import CSV data into exel sheets. ...
    (comp.unix.shell)