|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
generating a create ddl from a csv file using awk
Post 302363904 by jville on Wednesday 21st of October 2009 02:29:51 PM
10-21-2009
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I need to create a csv file to store oracle query output. This report need to be created on hourly basis. The csv file report format as "Report_22_Sep_09_13IST.csv". I have the oracle query. Now i need to create and move the oracle query output to the report row by row starting from 3rd row.... (6 Replies)
Discussion started by: Sekar1
6 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I need to create a .csv file from information that i have in two different tab delimited .txt file. I just want to select some of the columns of each .txt file and paste them into a .cvs file.
My files look like:
File 1
transcript_id Seq. Description Seq. Length ... (2 Replies)
Discussion started by: alisrpp
2 Replies
3. Shell Programming and Scripting
I created a script that will go out and so a "/sbin/chkconfig --list | egrep XXX" against a server list that would create an output file like the following example:
----------------------------------------------------------------------------------
SERVER1
RC_Script_1 0:off 1:off 2:off... (4 Replies)
Discussion started by: asnatlas
4 Replies
4. Shell Programming and Scripting
Hi I'm a beginner and I have some problem.
I have multiple files in the same directory which has one column but rows following the format.
File: directory/Disk.txt
Content:
a
b
c
d
e
File: directory/Memory.txt
a
b
c
d
e
File: directory/CPU.txt (3 Replies)
Discussion started by: thenuie
3 Replies
5. Shell Programming and Scripting
Hi List,
I have a chunk of data like so:
User Account Control:
User Account Control:
User Account Control:
User Account Control:
Disabled
User Account Control:
User Account Control:
User Account Control:
Disabled
User Account Control:
User Account Control:
... (3 Replies)
Discussion started by: landossa
3 Replies
6. UNIX for Dummies Questions & Answers
Hi Guys,
I have a simple request. I have a file in w3c format. Each file has 2 header lines. Rest of the lines are 16 columns each. They are separated by Tab. I need to discard the first 2 lines and then write each column of the txt file into a seperate column of CSV. I tried the command below... (1 Reply)
Discussion started by: tinkugadu
1 Replies
7. Shell Programming and Scripting
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies
8. Shell Programming and Scripting
Gents,
I am trying to create a csv file using the file attached.
I have a problem to get all information required because the rows are not continues.
Here is my code till now.
awk ' /"ffid"/{if(s){print s;s=$NF}else{s=$NF}}
/"LineNumber"/{s=s $NF}
/"PointNumber"/{s=s $NF}... (4 Replies)
Discussion started by: jiam912
4 Replies
9. Shell Programming and Scripting
I am extracting data via sql query and some of the data has commas. Output File must be csv and I cannot update the data in the db (as it is used by other application).
Example
table FavoriteThings
Person VARCHAR2(25),
Favorite VARCHAR2(100)
Sample Data
Greta rain drop on... (12 Replies)
Discussion started by: patk625
12 Replies
10. UNIX for Beginners Questions & Answers
Hi All ,
I would require your help to generate one output file after post processing of one CSV file as stated below
This file is just a small cut from a big file . Big file is having 20000 lines
PATTERN,pat0,pat1,pat2,pat3,pat4,pat5,pat6,pat7,pat8,pat9... (2 Replies)
Discussion started by: kshitij
2 Replies
LEARN ABOUT DEBIAN
py_xls2csv
py_xls2csv(1) General Commands Manual py_xls2csv(1) NAME
py_xls2csv - convert an Excel xls file to a comma separated value csv file SYNOPSIS
py_xls2csv input-file DESCRIPTION
This manual page was written for the Debian distribution because the original program does not have a manual page. py_xls2csv takes an Excel xls file as an argument and converts it to a comma separated value csv file. Output is sent to stdout. Additional utility scripts can be found in the tools/ directory. OPTIONS
This program does not take any command line options. AUTHOR
pyexcelerator and py_xls2csv were written by Roman V. Kiseliov <roman@kiseliov.ru>. This manual page was written by Kevin Coyner <kcoyner@debian.org> for the Debian system (but may be used by others). Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any later version published by the Free Software Foundation. On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL. SEE-ALSO pyexcelerator(1), py_xls2txt(1), py_xls2html(1) October 12, 2006 py_xls2csv(1)