Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Creating multiple worksheets in CSV file
Top Forums UNIX for Advanced & Expert Users Creating multiple worksheets in CSV file Post 302172444 by tekster757 on Monday 3rd of March 2008 05:26:41 PM
Old 03-03-2008
Creating multiple worksheets in CSV file
Yes, exactly what I was thinking regarding creating multiple csv files. I hadn't thought of macros though, thank you! I have no experience with macros, but from what I've heard they can do, that might be just the ticket for at least automating the updating of the monthly file. Then, as you said, load each vendor manually into excel.

Well, off I go to learn about macros - is that something that unix can do, or is that strictly a Windows or SAS thing?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

copying the csv file into different worksheets of xls file

Hi, I have a script which will generate three csv files. i want to copy the contents of these csv files into a .XLS file but in different worksheets. Can a this be done in the same script? :confused: Can Perl come to my help in coping the csv files into different worksheets of .XLS file ?... (0 Replies)
Discussion started by: nimish
0 Replies

2. Shell Programming and Scripting

creating a csv file in awk

Hi All I am trying to create a csv file in the korn shell and the script segment is as follows: if then # NEED TO ADD INFO TO THE EMAIL FILE ABOUT THE DRIVE THAT'S FILLING UP echo "$drive $percent% $space "|\ awk '{printf("%d/t"|"%d/t"|"%d/t\n",... (6 Replies)
Discussion started by: Segwar
6 Replies

3. UNIX for Dummies Questions & Answers

creating a CSV file for past 7 days

I have a requirement which will select the files with a specific naming convention which got created in past 7 days in a specific directory.Lets say the directory is /data/XYZ and the file names follow the below nomenclature like Daily_File*.txt I just need to create one CSV file which will... (12 Replies)
Discussion started by: dr46014
12 Replies

4. UNIX for Dummies Questions & Answers

Creating a report from csv file.

Hi Gurus, I need your help in transforming the CSV file into some what a report format. My source file looks like below Date,ProdID,TimeID,LevelID 2010-08-31,200,M,1 2010-08-31,201,Q,2 2010-08-31,202,Y,1 2010-08-31,203,M,5 Output required is ... (9 Replies)
Discussion started by: naveen.kuppili
9 Replies

5. Shell Programming and Scripting

creating a csv file from this 1 liner?

I'm trying to create a csv file by running awk and sed on a number of xml files in a directory; I'm using this below: hostname; grep "BuildDate" /dir/ABCD/configuration/*/*.xml | awk -F"/" '{ print $5 }' > /tmp/tempfile.txt; grep "BuildDate" /dir/ABCD/configuration/*/*.xml | awk -F\" '{ print $2... (2 Replies)
Discussion started by: rich@ardz
2 Replies

6. UNIX for Dummies Questions & Answers

Problem in creating CSV file

Hi guys, I am not experienced with Unix, so please dont mind if the question seem to be irrelevant. I have written a simple script, that connects DB & fetches few records from a table. I wanted to get those details as file in .CSV format via mail. -I stored the query o/p in a file. -I... (6 Replies)
Discussion started by: sumitburnwal88
6 Replies

7. Shell Programming and Scripting

reading a csv file and creating a flat file

hi i have written a script for reading a csv file and creating a flat file, suggest if this script can be optimized #---------------- FILENAME="$1" SCRIPT=$(basename $0) #-----------------------------------------// function usage { echo "\nUSAGE: $THIS_SCRIPT file_to_process\n"... (3 Replies)
Discussion started by: mprakasheee
3 Replies

8. UNIX for Dummies Questions & Answers

Creating a csv file with header in UNIX

I have a flat file that contains dynamic list of variables like a=1 b=2 c=3 . .. z=26 I need to convert the above into a csv file having the format below: a,b,c,..,z 1,2,3,..,26 Please note, I do not want a comma separating the last variable. I tried to refer the post... (4 Replies)
Discussion started by: vkumbhakarna
4 Replies

9. Shell Programming and Scripting

How to split multiple worksheets into multiple files?

Dear all, My source contains excel file with multiple worksheets. As part of project requirement I need to split all the worksheets into multiple files in ETL. For Example, Source File (A.xls) contains multiple worksheets B,C,D then Output should B.xls C.xls D.xls Can anybody help me... (1 Reply)
Discussion started by: Abhisrajput
1 Replies

10. UNIX for Advanced & Expert Users

Shell script for dealing with XLS file with multiple tabs/worksheets

Hey Guys , Recently working on a requirement , i had to deal with XLS file with multiple tabs and the requirement was as below : 1. Convert one XLS file with multiple tabs to multiple CSV files. -- As i was working on MAC , so it was quite easy through APPLESCRIPT to deal with this.But... (2 Replies)
Discussion started by: himanshu sood
2 Replies

LEARN ABOUT PLAN9

groff_mom

GROFF_MOM(7)						 Miscellaneous Information Manual					      GROFF_MOM(7)

NAME

       groff_mom - groff `mom' macros

SYNOPSIS

       groff -mom [ files... ]
       groff -m mom [ files... ]

DESCRIPTION

       mom  ("my own macros", "my other macros", "maximum overdrive macros", ...) is a macro set for groff, designed primarily to format documents
       for PostScript output.

       mom provides two categories of macros: macros for typesetting and macros for document processing.  The typesetting macros provide access to
       groff's	typesetting  power  in ways that are simpler to master and to use than groff's primitives.  The document processing macros provide
       customizable markup "tags" that allow the user to design and output professional-looking documents with a minimum of typesetting  interven-
       tion.

       mom comes with her own (very) complete documentation in HTML format.

FILES

       om.tmac
	      - the main macro file
       mom.tmac
	      - a wrapper file that calls om.tmac directly.

       </usr/share/doc/groff-base/html/mom/toc.html>
	      - entry point to the HTML documentation

       /usr/share/doc/groff-base/examples/mom/*
	      - example files using mom

AUTHOR

       mom  was  written  by  Peter  Schaffter <peter@schaffter.ca>.  Please send bug reports to the groff bug mailing list <bug-groff@gnu.org> or
       directly to the author at the address, above.

Groff Version 1.21						   25 June 2012 						      GROFF_MOM(7)
All times are GMT -4. The time now is 01:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy