09-15-2014
@MadeINGermany
Thanks. I changed the locale settings and it's working.
But the only problem I saw is when there is no values in some of the columns then the file looks like ;;;; with just separators.
The code is removing one of the last separator ";". When it contains no values then it will show just multiple separators like ;;;; .
It is removing the last ";" at the end of few lines (rows). I have provided the example below. Left section is input and the right one is output where you can see one of the ";" is removed by the program.
And if the column is added in the last it is not getting reported in the mismatch.txt. It is reporting only when the columns are added in the middle. Can you please let me know how to resolve this issue of one missing ";" at the end of few rows? and how to report if the column or columns are added at the end or middle or beginning?
Merlin Joseph
Last edited by Merlin Joseph; 09-15-2014 at 09:22 AM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I want to create column names in a flat file and then load the data through some other application. For example, I have a file with emp.txt and I need column names as eno,ename,sal in the first line. The delimiter here is comma and record delimiter is end of line or unix new line. Could... (1 Reply)
Discussion started by: srivsn
1 Replies
2. Shell Programming and Scripting
Hi,
I want to write a script which will compare the 1st column of both the files and will give the difference.
e.g:-
my 1st file contains:
89 /usr
52 /usr/local
36 /tmp
92 /opt
96 /home
27 /etc/opt/EMCom
1 ... (3 Replies)
Discussion started by: adityam
3 Replies
3. Shell Programming and Scripting
Hi All,
i have a file that is tab delimited. i need help to find the rows which are having same price based on the site code but some times, there are difference so i need to find only the records which are different in all site code.
Dept Sec Barcode 10001 10002 10003 10004... (1 Reply)
Discussion started by: malcomex999
1 Replies
4. Shell Programming and Scripting
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (1 Reply)
Discussion started by: Vavad
1 Replies
6. UNIX for Dummies Questions & Answers
I have a table, say this:
name1 num1 num2 num3 num4
name2 num5 num6 num7 num8
name3 num1 num3 num4 num9
name2 num8 num9 num1 num2
name2 num4 num5 num6 num4
name4 num4 num5 num7 num8
name5 num1 num3 num9 num7
name5 num6 num8 num3 num4
I want a code that will sort my data according... (4 Replies)
Discussion started by: FelipeAd
4 Replies
7. Shell Programming and Scripting
Hi , i am newbie to shell scripting and am trying to do the below job,
A shell script to be run with a command like
sh Compare.ksh file1.txt file2.txt 1 2 > file3.txt
1 2-are the key columns
Consider the delimiter would be Tab or comma
File 1:
SK TEST NAME MATHS PHYSICS
21 1... (1 Reply)
Discussion started by: shakthi666
1 Replies
8. Homework & Coursework Questions
Hi , i am newbie to shell scripting and am trying to do the below job,
A shell script to be run with a command like
sh Compare.ksh file1.txt file2.txt 1 2 > file3.txt
1 2-are the key columns
Consider the delimiter would be Tab or comma
File 1:
SK TEST NAME MATHS PHYSICS
21 1 AAA... (1 Reply)
Discussion started by: shakthi666
1 Replies
9. Shell Programming and Scripting
File 1:
20130416,235800,10.78.25.104,BR2-loc,60.0,1624,50.0,0,50.0,0
20130416,235800,10.78.25.104,BR1-LOC,70.0,10,50.0,0,70.0,0
20130416,235800,10.78.25.104,Hub_None,60.0,15,60.0,0,50.0,0
File 2:
20130417,000200,10.78.25.104,BR2-loc,60.0,1626,50.0,0,50.0,0... (3 Replies)
Discussion started by: Lakshmikumari
3 Replies
10. Shell Programming and Scripting
In a bash shell, I have to prefix a variable to two .CSV files File1.CSV and File2.CSV. One of the files has a header and the other one is with no header in the below format:
"value11","value12","value13","value14","value15","value16"
"value21","value22","value23","value24","value25","value26"... (7 Replies)
Discussion started by: dhruuv369
7 Replies
LEARN ABOUT DEBIAN
gpiv_t-avg-img
GPIV_T-AVG-IMG(1) General Commands Manual GPIV_T-AVG-IMG(1)
NAME
gpiv_t-avg-img - Calculates time-averaged intensities from a series of images at each pixel.
SYNOPSIS
gpiv_t-avg-img [-c int] [-fb string] [-ff int] [-fl int] [-fx] [-help] [-p | --print] [-r int] [-s] [-v] < stdin > stdout
DESCRIPTION
gpiv_t-avg-img calculates time-averaged intensities from a series of images for each pixel. This program uses the GENPAR parameters.
Options
-c NCOLS
Number of columns.
-fb FILE
File base-name (without .number.r extension) instead of stdin and stdout.
-ff N Number of first image file.
-fl N Number of last image file.
-fx Prefix numbering to file base name.
-help | --help
On-line help.
-p | --print
Prints parameters, command line options and input and output filenames to stdout.
-r NROWS
Number of rows.
-s Subtract mean from input data. -v | --version Prints version information to standard output, then exits successfully.
SEE ALSO
gpivtools
AUTHOR
Gerber Van der Graaf
19 Januari 2005 GPIV_T-AVG-IMG(1)