am using bash shell below is just the part of the code i am using. the script needs a parameter for it to run.
Code:
Infile=$1
NotFinalOutFile=`echo $Infile | awk -F '.' '{print $1}'`
for files in `echo $Infile`
do
sed 's/[ \t]*$//' $files | \
sed 's/^$/)\n/' | egrep -vw 'Name|-' | \
sed -e 's/desc/CREATE TABLE/;/CREATE / a\(' | \
awk '{
sub(/^\)/,"&;"); # Replace ")" with ");"
s=($0~/^[A-Z]/&& a~/^[A-Z]/ && !/"^CREATE "/)?",":""; # IF this line and previous line start with "A-Z" and not "CREATE" set "s" to "," else set it to ""
printf s"\n%s", # Print this line "$0" using "s" as formating pluss new line
a=$0} # Set a=this line
END {
print ""}' # Print a new line
done >> $NotFinalOutFile.dat
---------- Post updated at 03:01 PM ---------- Previous update was at 02:48 PM ----------
actually, the script above just creates the create table statement.
---------- Post updated at 03:04 PM ---------- Previous update was at 03:01 PM ----------
below is the sample input file for the script:
Code:
desc a
Name Null Type
------------ -------- ------------
TRIAL_CLIENT NOT NULL VARCHAR2(60)
TRIAL_FUND NOT NULL VARCHAR2(60)
LOCAL_ACC_NO NOT NULL VARCHAR2(60)
TRIAL_BROKER NOT NULL VARCHAR2(12)
CORR_ACC_NO NOT NULL NUMBER(10)
CURRENCY NOT NULL VARCHAR2(3)
VALUE_DATE NOT NULL DATE
desc b
Name Null Type
------------------------- -------- ------------
TRIAL_CLIENT NOT NULL VARCHAR2(60)
TRIAL_FUND NOT NULL VARCHAR2(60)
LOCAL_ACC_NO NOT NULL VARCHAR2(60)
TRIAL_BROKER NOT NULL VARCHAR2(12)
CORR_ACC_NO NOT NULL NUMBER(10)
CURRENCY NOT NULL VARCHAR2(3)
AS_OF_DATE NOT NULL DATE
SUM_OUR_CASH_TXNS NUMBER
SUM_OUR_POSITIONS NUMBER
COUNT_OUR_TRANSACTIONS NUMBER
SUM_OUR_CASH_BALS NUMBER
SUM_OUR_UNREAL_BALS NUMBER
SUM_BROKER_CASH_TXNS NUMBER
SUM_BROKER_POSITIONS NUMBER
COUNT_BROKER_TRANSACTIONS NUMBER
SUM_BROKER_CASH_BALS NUMBER
SUM_BROKER_UNREAL_BALS NUMBER
SUM_UNSETT_INT NUMBER
SUM_OPEN_FWDS NUMBER
WO_AMT NUMBER
Hi Everyone,
I have a flat file of 1000 unique records like following : For eg
Andy,Flower,201-987-0000,12/23/01
Andrew,Smith,101-387-3400,11/12/01
Ani,Ross,401-757-8640,10/4/01
Rich,Finny,245-308-0000,2/27/06
Craig,Ford,842-094-8740,1/3/04
.
.
.
.
.
.
Now I want to duplicate... (9 Replies)
Hi experts,
I am new to scripting. I have a requirement as below.
File1:
A|123|NAME1
A|123|NAME2
B|123|NAME3
File2:
C|123|NAME4
C|123|NAME5
D|123|NAME6
1) I have 2 merge both the files.
2) need to do a sort ( key fields are first and second field)
3) remove all the instances... (3 Replies)
Can any one give me command How to delete duplicate records with out sort.
Suppose if the records like below:
345,bcd,789
123,abc,456
234,abc,456
712,bcd,789
out tput should be
345,bcd,789
123,abc,456
Key for the records is 2nd and 3rd fields.fields are seperated by colon(,). (2 Replies)
Can any one give me command How to delete duplicate records with out sort.
Suppose if the records like below:
345,bcd,789
123,abc,456
234,abc,456
712,bcd,789
out tput should be
345,bcd,789
123,abc,456
Key for the records is 2nd and 3rd fields.fields are seperated by colon(,). (19 Replies)
I want to remove the records based on duplicate. I want to remove if two or more records exists with combination fields. Those records should not come once also
file abc.txt
ABC;123;XYB;HELLO;
ABC;123;HKL;HELLO;
CDE;123;LLKJ;HELLO;
ABC;123;LSDK;HELLO;
CDF;344;SLK;TEST
key fields are... (7 Replies)
Hi frinds,
Need your help.
item , color ,desc
==== ======= ====
1,red ,abc
1,red , a b c
2,blue,x
3,black,y
4,brown,xv
4,brown,x v
4,brown, x v
I have to elemnet the duplicate rows on the basis of item.
the final out put will be
1,red ,abc (6 Replies)
I have a flat file that contains records similar to the following two lines;
1984/11/08 7 700000 123456789 2
1984/11/08 1941/05/19 7 700000 123456789 2
The 123456789 2 represents an account number, this is how I identify the duplicate record.
The ### signs represent... (4 Replies)
Consider my input is
10
10
20
then,
uniq -u will give 20 and uniq -dwill return 10.
But i need the output as ,
10
10
How we can achieve this?
Thanks (4 Replies)
I have 2 files
"File 1" is delimited by ";" and "File 2" is delimited by "|".
File 1 below (3 record shown):
Doc1;03/01/2012;New York;6 Main Street;Mr. Smith 1;Mr. Jones
Doc2;03/01/2012;Syracuse;876 Broadway;John Davis;Barbara Lull
Doc3;03/01/2012;Buffalo;779 Old Windy Road;Charles... (2 Replies)
Gents,
Please give a help
file
--BAD STATUS NOT RESHOOTED--
*** VP 41255/51341 in sw 2973
*** VP 41679/51521 in sw 2973
*** VP 41687/51653 in sw 2973
*** VP 41719/51629 in sw 2976
--BAD COG NOT RESHOOTED--
*** VP 41689/51497 in sw 2974
*** VP 41699/51677 in sw 2974
*** VP... (18 Replies)
Discussion started by: jiam912
18 Replies
LEARN ABOUT DEBIAN
ptpd
ptpd(8) Precision Time Protocol daemon ptpd(8)NAME
ptpd - Precision Time Protocol daemon (1588-2008)
SYNOPSIS
ptpd [?] [-c] [-S] [-f FILE] [-R FILE] [-d] [-D] [-x] [-M NUMBER] [-t] [-T ttl] [-a NUMBER,NUMBER] [-w NUMBER] [-b NAME] [-u ADDRESS] [-e]
[-h] [-l NUMBER,NUMBER] [-o NUMBER] [-i NUMBER] [-n NUMBER] [-y NUMBER] [-m NUMBER] [-g] [-v NUMBER] [-r NUMBER] [-s NUMBER] [-p NUMBER]
[-q NUMBER]
DESCRIPTION
Implements the Precision Time Protocol (PTP) Version 2 as defined by the IEEE 1588-2008 standard. PTP was developed to provide very precise
time coordination of LAN connected computers.
PTPd is a complete implementation of the IEEE 1588 v2 specification for a standard (ordinary) clock. PTPd has been tested with and is known
to work properly with other IEEE 1588 implementations. The source code for PTPd is freely available under a BSD-style license. Thanks to
contributions from users, PTPd is becoming an increasingly portable, interoperable, and stable IEEE 1588 implementation.
For more information, see http://ptpd.sourceforge.net/
OPTIONS
-? display a short help text
-c run in command line (non-daemon) mode
-S log information to syslog
-f FILE
send output to FILE
-R FILE
record a quality FILE
-d display stats
-D display stats in .csv format
-x do not reset the clock if off by more than one second
-M NUMBER
do not reset the clock if off by more than NUMBER nanoseconds
-t do not adjust the system clock
-T set multicast TTL for packets. Defaults to 1.
-a NUMBER,NUMBER
specify clock servo P and I attenuations
-w NUMBER
specify one way delay filter stiffness
-b NAME
bind PTP to network interface NAME
-u ADDRESS
also send uni-cast to ADDRESS
-e run in ethernet mode (level2)
-h run in End to End mode
-l NUMBER,NUMBER
specify inbound, outbound latency in nsec
-o NUMBER
specify current UTC offset
-i NUMBER
specify PTP domain number
-n NUMBER
specify announce interval in 2^NUMBER sec
-y NUMBER
specify sync interval in 2^NUMBER sec
-m NUMBER
specify max number of foreign master records
-g run as slave only
-v NUMBER
specify system clock allen variance
-r NUMBER
specify system clock accuracy
-s NUMBER
specify system clock class
-p NUMBER
specify priority1 attribute
-q NUMBER
specify priority2 attribute
AUTHOR
Gael Mace <gael_mace@users.sourceforge.net> & Alexandre Van Kempen.
Steven Kreuzer <skreuzer@freebsd.org>
George Neville-Neil <gnn@freebsd.org>
This manual page was written by Gael Mace for any Linux environment project.
version 2.1.0 October, 2010 ptpd(8)