09-24-2011
Thaaanks...
Thanks bartus11
..
Now i have one more complication in the above question...
I have the dat file similar to the one as shown below..(column 5 will have only 7 or 8 and all the 7's and 8's are grouped)
|A|B|C||7|E
|F|G|H||7|J
|K|L|M||8|O
|P|Q|R||8|T
As shown above, the column 4 is currently blank and i need to insert sequence numbers into it, also now the sequence number depends upon the column 5, ie if the column 5 = 7 then column 4 will have one set of sequence numbers, for column 5 = 8 then again the sequence should start from 1 so that the new data file becomes as shown below.
|A|B|C|1|7|E
|F|G|H|2|7|J
|K|L|M|1|8|O
|P|Q|R|2|8|T
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi:
I have a text file date(pipe delimited) which is loaded in to the DB using sql loader(&CTL files) after some initial validation by the shell script.
Now i have a situation where the shell script needs to check a column in the text file and if it is NULL then it needs send this record/row... (12 Replies)
Discussion started by: ravi0435
12 Replies
2. Shell Programming and Scripting
Hi, could some help me convert CSV file (with double quoted strings) to pipe delimited file:
here you go with the same data:
1,Friends,"$3.99 per 1,000 listings",8158here " 1,000 listings " should be a single field.
Thanks,
Ram (8 Replies)
Discussion started by: Ram.Math
8 Replies
3. Shell Programming and Scripting
this is Korn shell unix.
The scenario is I have a pipe delimited text file which needs to be customized. say for example,I have a pipe delimited text file with 15 columns(| delimited) and 200 rows. currently the 11th and 12th column has null values for all the records(there are other null columns... (4 Replies)
Discussion started by: vasan2815
4 Replies
4. Homework & Coursework Questions
hi,
I have pipe delimited flat file as below
1|ab|4.5|9|
2|ac|3|12|
3|ac|4.5|8|
i want to show (display) only 3rd field between pipes.
please help (1 Reply)
Discussion started by: vai15517
1 Replies
5. Shell Programming and Scripting
Hello All,
Thanks for taking time to read through the thread and for providing any possible solution.
I am trying to pivot a comma separated field in a pipe delimited file. Data looks something like this:
Field1|Field2
123|345,567,789
234|563,560
345|975,098,985,397,984
456|736
Desired... (8 Replies)
Discussion started by: svks1985
8 Replies
6. Shell Programming and Scripting
Hi,
I have a pipe delimited file as below and I need to replace the 2nd column of each line with null values.
1|10/15/2011|fname1|lname1
2|10/15/2012|fname2|lname2
3|10/15/2013|fname3|lname3
Output file:
1||fname1|lname1
2||fname2|lname2
3||fname3|lname3
I tried this
... (2 Replies)
Discussion started by: member2014
2 Replies
7. Shell Programming and Scripting
Hi All ,
I have pipe delimiter file with 11 columns . I need to insert 4 empty columns after column 10 . and After 11 column I need to insert a column which is having the same value for all the rows .
My file
1|2|3|4|5|6|7|8|9|10|11
New file
... (11 Replies)
Discussion started by: Hypesslearner
11 Replies
8. Shell Programming and Scripting
Hi All,
I have a file which has data like
a,b
c,d
e,f
g,h
And I need to insert a new column at the begining with sequence no( 1 to n)
1,a,b
2,c,d
3,e,f
4,g,h
Please let me know how to acheive this in unix (3 Replies)
Discussion started by: weknowd
3 Replies
9. Shell Programming and Scripting
Hi,
I need to remove first column from a csv file and i can do this by using below command.
cut -f1 -d, --complement Mytest.csv
I need to implement this in shell scripting, Whenever i am using the above command alone in command line it is working fine.
I have 5 files in my directory and... (3 Replies)
Discussion started by: Samah
3 Replies
10. Shell Programming and Scripting
I have an input file as below
Emp1|FirstName|MiddleName|LastName|Address|Pincode|PhoneNumber
1234|FirstName1|MiddleName2|LastName3| Add1 || ADD2|123|000000000
Output :
1234|FirstName1|MiddleName2|LastName3| Add1 ,, ADD2|123|000000000
OR
1234,FirstName1,MiddleName2,LastName3, Add1 ||... (2 Replies)
Discussion started by: styris
2 Replies
kst(1) kst2 kst(1)
NAME
kst -- plots scientific data
SYNOPSIS
kst
kst [ -F DATASOURCE ] [ -f STARTFRAME ] [ -n NUMFRAMES ] [ -s FRAMESPERSAMPLE [ -a ] ] kstfile
kst datasource [ -f STARTFRAME ] [ -n NUMFRAMES ] [ -s FRAMESPERSAMPLE [ -a ] ] [ -P PLOTNAME ] [ -A] [ -d ] [ -l ] [ -b ] [ -x FIELD ]
[ -e FIELD ] [ -r RATE ] [ -y FIELD ] [ -p FIELD ] [ -h FIELD ] [ -z FIELD ] [ --png filename ] [ --print filename [ --landscape |
--portrait ] [ --Letter | --A4 ] ]
DESCRIPTION
kst is a graphical data plotting tool, which includes the ability to plot live data (contiuously update the plot as new data becomes avail-
able).
kst may be run entirely from within its GUI, in which case no command line arguments are needed. kst has a powerful wizard for easily set-
ting up new plots.
In the second invocation, kst loads pre-saved plot specifications from the file kstfile and optionally may override some of the settings in
that file.
In the third invocation, kst displays plots of the data as directed in the default manner. Additional datasources may be specified on the
command line with options for that datasource following it. Command line options generally apply to all subsequent options unless later
overridden.
OPTIONS
-A plot all curves in separate plots
-a average frames (simple mean) when plotting with -s.
--A4 use A4 sized paper for printing. Requires --print.
-b plot as bargraphs.
-d use points when plotting curves.
-e FIELD
use FIELD as the magnitude of error bars applied to the next plot.
-F datasource
override the datasource indicated in the kstfile and instead use datasource.
-f STARTFRAME
begin plotting at STARTFRAME frames into the data. Set to -1 to start at NUMFRAMES from the end of the data.
-h FIELD
plot FIELD as a histogram.
-l use lines when plotting curves.
--landscape
use landscape orientation for printing. Requires --print. --Letter use US Letter sized paper for printing. Requires --print.
-n NUMFRAMES
plot at most NUMFRAMES frames of data. Set to -1 to indicate all of the data.
-P PLOTNAME
plot all plots in the plot named PLOTNAME.
-p FIELD
plot FIELD as a power spectrum plot.
--png filename
render to a portable network graphics (png) image with file name filename and quit.
--portrait
use portrait orientation for printing. Requires --print.
--print filename
print the plot to file filename and quit.
-s FRAMESPERSAMPLE
plot every FRAMESPERSAMPLE frames when plotting.
-x FIELD
use FIELD as the X-axis vector.
-y FIELD
plot FIELD as an XY plot.
-z FIELD
plot FIELD as an image.
EXAMPLES
Plot all data in column 2 from data.dat.
kst data.dat -y 2
Same as above, except only read 20 lines, starting at line 10.
kst data.dat -f 10 -n 20 -y 2
also read col 1. One plot per curve.
kst data.dat -f 10 -n 20 -y 1 -y 2
Read col 1 from data2.dat and col 1 from data.dat
kst data.dat -f 10 -n 20 -y 2 data2.dat -y 1
Same as above, except read 40 lines starting at 30 in data2.dat
kst data.dat -f 10 -n 20 -y 2 data2.dat -f 30 -n 40 -y 1
Specify the X vector and error bars: Plot x = col 1 and Y = col 2 and error flags = col 3 from data.dat
kst data.dat -x 1 -e 3 -y 2
Get the X vector from data1.dat, and the Y vector from data2.dat.
kst data1.dat -x 1 data2.dat -y 1
Placement: Plot column 2 and column 3 in plot P1 and column 4 in plot P2
kst data.dat -P P1 -y 2 -y 3 -P P2 -y 4
BUGS
Please report bugs to either the kst mailing list at kst@kde.org or to the kde bugzilla under the kst product at http://bugs.kde.org/. If
you can run kst, you can easily report bugs by selecting Bug Report Wizard from the Help menu.
AUTHOR
Matthew Truch <matt@truch.net>
LICENSE
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or
any later version published by the Free Software Foundation; with no Invariant Sections, with no Front-Cover Texts, and with no Back-Cover
Texts. A copy of the license is included in the `COPYING.DOC' file as part of the kst distribution.
Version 2.0.3 22 February 2011 kst(1)