04-18-2019
Thank you
it worked ,my Bad
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a file as follows:
1,"This is field 2",3,4,5
2,"This is field 2 it can contain one , comma",3,4,5
3,"This is field 2 it also, can, contain, more",3,4,5
4,"This is field 2 without extra commas",3,4,5
and i pass this through to awk:
awk -F, ' {
if (... (3 Replies)
Discussion started by: Cranie
3 Replies
2. Shell Programming and Scripting
Hello People
I have the following file.csv:
date,string,float,number,boolean
20080303,abc,1.5,123,Y
20080304,abc,1.2,345,N
20080229,nvh,1.4,098,Y
20080319,ugy,1.9,586,N
20080315,gyh,2.4,345,Y
20080316,erf,3.1,932,N
I need to filter the date field where I have a data bigger than I... (1 Reply)
Discussion started by: Rafael.Buria
1 Replies
3. UNIX for Dummies Questions & Answers
Hi
Here is my script that calls my awk script
#!/bin/bash
set -x
dir="/var/local/dsx/csv"
testfile="$testfile"
while getopts " f: " option
do
case $option in
f ) testfile="$OPTARG";;
esac;
done
./scriptFile --testfile=$testfile >> $dir/$testfile.csv
It calls my awk... (1 Reply)
Discussion started by: ladyAnne
1 Replies
4. Shell Programming and Scripting
Hi All,
I am new to shell scripting..My problem is i want to give multiple csv files as input to awk script and process the data into one file..
My input file is
File1 File2 File3
Product Location Period SalesPrice
A x 8/11/2010 ... (7 Replies)
Discussion started by: kvth
7 Replies
5. Shell Programming and Scripting
I have 2 files pipe delimted and want to merge them based on a key
e.g file 1
123$aaa$yyy$zzz
345$xab$yzy$zyz
456$sss$ttt$foo
799$aaa$ggg$dee
file 2
123$hhh
345$ddd
456$xxx
888$zzz
so if the key is the first field, and the result should be the common key between file 1 and 2 (6 Replies)
Discussion started by: loloAix
6 Replies
6. Shell Programming and Scripting
Dear awk users,
I am trying to use awk to match records across two moderately large CSV files. File1 is a pattern file with 173,200 lines, many of which are repeated. The order in which these lines are displayed is important, and I would like to preserve it. File2 is a data file with 456,000... (3 Replies)
Discussion started by: isuewing
3 Replies
7. Shell Programming and Scripting
Hi,
I am new to awk/unix and am trying to put together an awk script to perform an action similar to vlookup between the two csv files.
Here are the contents of the two files:
File 1:
Date,ParentID,Number,Area,Volume,Dimensions
2014-01-01,ABC,247,83430.33,857.84,8110.76... (9 Replies)
Discussion started by: Prit Siv
9 Replies
8. Shell Programming and Scripting
Hello Gentlemen,
Finding difficulties to play with my Input files:confused: . Your guidance will certainly help as always.
After converting to csv file from XLSM file, I am getting some extra ""(double quote) characters which I want to terminate inside shell script and process it further.
... (6 Replies)
Discussion started by: pradyumnajpn10
6 Replies
9. UNIX for Beginners Questions & Answers
Hello all,
I have searched high and low for a solution to this, many have come really close but not quite what I'm after.
I have 2 files. One contains GUID's, for example:
8121E002-96FE-4C9C-BC5A-6AFF20DACECD
84468F30-F3B7-418B-81F0-0908E80792BF
A second file, contains a path to the... (8 Replies)
Discussion started by: tirmUK
8 Replies
10. Shell Programming and Scripting
Hello everyone!
I have thousands of csv files I have to import into a Database table. As usually the files aren't perfect. For example they have a different number of columns and some weird columns.
The second problem is, that I have to add 3 parts of the filename into 3 rows in the... (6 Replies)
Discussion started by: elRonaldo
6 Replies
LEARN ABOUT DEBIAN
cqtest
CQTEST(8) System Manager's Manual CQTEST(8)
NAME
cqtest - HylaFAX copy quality checking test program
SYNOPSIS
/usr/sbin/cqtest [ options ] input.tif
DESCRIPTION
cqtest is a program for testing the copy quality checking support in the HylaFAX software (specifically, in the faxgetty(8) program).
cqtest takes a TIFF/F (TIFF Class F) file and generates a new TIFF/F file that is a copy of the input file, but with any erroneous scan-
lines replaced/regenerated. In addition, cqtest prints diagnostic messages describing its actions and indicates whether the input data has
acceptable copy quality according to the copy quality checking threshold parameters. Options are provided for specifying copy quality
checking threshold parameters
OPTIONS
-m badlines Set the maximum consecutive bad lines of data that may appear in each acceptable page of input data. This is equivalent to
the MaxConsecutiveBadLines configuration parameter; c.f. hylafax-config(5). By default cqtest accepts no more than 5 con-
secutive bad lines in a page.
-o file Write output to file. By default output is written to the file cq.tif.
-p %goodlines Set the minimum percentage of ``good lines'' of data that may appear in acceptable page of input data. A line is good if it
decodes without error to a row of pixels that is the expected width. This is equivalent to the PercentGoodLines configura-
tion parameter; c.f. hylafax-config(5). By default cqtest requires that 95% of the rows of each page be good.
EXAMPLES
The following shows a multi-page, high-resolution document with a single error on each page. Each page has acceptable copy quality using
the default threshold parameters.
hyla% /usr/sbin/cqtest ~/tiff/pics/faxix.tif
1728 x 297, 7.7 line/mm, 1-D MH, lsb-to-msb
RECV/CQ: Bad 1D pixel count, row 245, got 1616, expected 1728
RECV: 2234 total lines, 1 bad lines, 1 consecutive bad lines
1728 x 297, 7.7 line/mm, 1-D MH, lsb-to-msb
RECV/CQ: Bad 1D pixel count, row 148, got 3023, expected 1728
RECV: 2234 total lines, 1 bad lines, 1 consecutive bad lines
1728 x 297, 7.7 line/mm, 1-D MH, lsb-to-msb
RECV/CQ: Bad 1D pixel count, row 151, got 1722, expected 1728
RECV: 2234 total lines, 1 bad lines, 1 consecutive bad lines
1728 x 297, 7.7 line/mm, 1-D MH, lsb-to-msb
RECV/CQ: Bad 1D pixel count, row 148, got 1776, expected 1728
RECV: 2234 total lines, 1 bad lines, 1 consecutive bad lines
SEE ALSO
faxgetty(8), hylafax-config(5)
October 3, 1995 CQTEST(8)