Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: generating a create ddl from a csv file using awk
Top Forums Shell Programming and Scripting generating a create ddl from a csv file using awk Post 302364387 by summer_cherry on Friday 23rd of October 2009 01:15:01 AM
Old 10-23-2009
Code:
my %tables;
while(<DATA>){
 chomp;
 my @tmp=split(",",$_);
 if ($tmp[2] eq "VARCHAR2"){
    $tables{$tmp[0]}->{$tmp[1]}->{val}=$tmp[2]." (".$tmp[3].")";
    $tables{$tmp[0]}->{$tmp[1]}->{seq}=$.;
 }
 elsif($tmp[2] eq "NUMBER"){
    $tables{$tmp[0]}->{$tmp[1]}->{val}=$tmp[2]." (".$tmp[3].",".$tmp[4].")";
    $tables{$tmp[0]}->{$tmp[1]}->{seq}=$.;
 }
 else{
    $tables{$tmp[0]}->{$tmp[1]}->{val}=$tmp[2];
    $tables{$tmp[0]}->{$tmp[1]}->{seq}=$.;
 }
}
for my $key (keys %tables){
  print "CREATE TABLE ",$key,"(\n";
  for my $k (sort {$tables{$key}->{$a}->{seq} <=> $tables{$key}->{$b}->{seq}} keys %{$tables{$key}}){
    print $k," ",$tables{$key}->{$k}->{val},",\n";
  }
  print ");\n\n";
}
__DATA__
TEST1,fld1,VARCHAR2,3,,,
TEST1,fld2,DATE,,,,
TEST1,fld3,VARCHAR2,51,,,
TEST1,fld4,VARCHAR2,2,,,
TEST1,fld5,NUMBER,4,0,,
TEST1,fld6,VARCHAR2,1,,,
TEST1,fld7,TIMESTAMP,,,NOT NULL,
TEST1,fld8,VARCHAR2,16,,NOT NULL,1
TEST2,COLUMN1,VARCHAR2,100,,,
TEST2,COLUMN2,VARCHAR2,16,,NOT NULL,1
TEST2,COLUMN3,DATE,,,,
TEST2,COLUMN4,VARCHAR2,30,,,
TEST2,COLUMN5,VARCHAR2,30,,,
TEST2,COLUMN6,NUMBER,17,2,,
TEST2,COLUMN7,VARCHAR2,15,,NOT NULL,2
TEST3,COLUMN1,TIMESTAMP,,,NOT NULL,1

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Command to create and update csv file

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

How to create a .csv file from 2 different .txt files?

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

Script to create a CSV file

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

Need help. How to create csv file?

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

Generating CSV from Column data

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

Generating a CSV file from a text file

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

Compare 2 files of csv file and match column data and create a new csv file of them

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

Create csv from text file

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

Is there a way to handle commas inside the data when generating a csv file from shell script?

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

awk and sed script to create one output CSV file

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 PLAN9

dh_movefiles

DH_MOVEFILES(1) 						     Debhelper							   DH_MOVEFILES(1)

NAME

       dh_movefiles - move files out of debian/tmp into subpackages

SYNOPSIS

       dh_movefiles [debhelperoptions] [--sourcedir=dir] [-Xitem] [file...]

DESCRIPTION

       dh_movefiles is a debhelper program that is responsible for moving files out of debian/tmp or some other directory and into other package
       build directories. This may be useful if your package has a Makefile that installs everything into debian/tmp, and you need to break that
       up into subpackages.

       Note: dh_install is a much better program, and you are recommended to use it instead of dh_movefiles.

FILES

       debian/package.files
	   Lists the files to be moved into a package, separated by whitespace. The filenames listed should be relative to debian/tmp/. You can
	   also list directory names, and the whole directory will be moved.

OPTIONS

       --sourcedir=dir
	   Instead of moving files out of debian/tmp (the default), this option makes it move files out of some other directory. Since the entire
	   contents of the sourcedir is moved, specifying something like --sourcedir=/ is very unsafe, so to prevent mistakes, the sourcedir must
	   be a relative filename; it cannot begin with a `/'.

       -Xitem, --exclude=item
	   Exclude files that contain item anywhere in their filename from being installed.

       file ...
	   Lists files to move. The filenames listed should be relative to debian/tmp/. You can also list directory names, and the whole directory
	   will be moved. It is an error to list files here unless you use -p, -i, or -a to tell dh_movefiles which subpackage to put them in.

NOTES

       Note that files are always moved out of debian/tmp by default (even if you have instructed debhelper to use a compatibility level higher
       than one, which does not otherwise use debian/tmp for anything at all). The idea behind this is that the package that is being built can be
       told to install into debian/tmp, and then files can be moved by dh_movefiles from that directory. Any files or directories that remain are
       ignored, and get deleted by dh_clean later.

SEE ALSO

       debhelper(7)

       This program is a part of debhelper.

AUTHOR

       Joey Hess <joeyh@debian.org>

11.1.6ubuntu2							    2018-05-10							   DH_MOVEFILES(1)
All times are GMT -4. The time now is 04:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy