i have a file named file_names.dat where there are several files along with their path.
exp:
/data1/dir1/CTA_ACD_20071208.dat
/data1/dir1/CTA_DFG_20071208.dat
i want to write a script which will create a csv file with the name of the file and record count of that file
the output file... (4 Replies)
HI ,
I am new to shell scripting ,
I have a requirement that
I send a file for data quality ( original.csv) & i will be getting 4 files daily into a particular directory in return with cleansed data .
the files may be clean.csv,
unclean.csv ,
... (2 Replies)
Hello Gurus,
We have a requirement to count the valid number of records in a comma delimited file with double quotes.
The catch here is..few records have a new line carriage within the double quotes,,say for ex:we have a file called accounts the record count is 4827..but the actual valid count... (5 Replies)
i use unix command to take the record count for a file1
awk 'END{print NR}' filename
i already have a file2 which conatin the count like
...
..
rec_cnt=100
..
..
I want to replace the record in the file2 using the record i take from file1.
suggest me some simple ways of doing it... (2 Replies)
Hi all this is a UNIX question.
I have a large flat file with millions of records.
col1|col2|col3
1|a|b
2|c|d
3|e|f
3|g|h
footer****
I am supposed to calculate the sum of col1 1+2+3+3=9, count of col1 1,2,3,3=4, and distinct count of col1 1,2,3=c3
I would like it if you avoid... (4 Replies)
Hi all
How to verify the number of records in case of delimited file, If the file has records. And then if it is not equal to mentioned no. of records, email is triggered and file is moved to bad directory path.
Example
-----
input file = a.txt
bad directory path : /usr/bin/bad (6 Replies)
HI,
I need to print the record count of a file using shell script.
If the record count of a file excluding header and trailer record if greater than zero then print 'Record count of a file is xxxx records'.
If the record count is zero print 'zero records'
Thanks
Mahendra (1 Reply)
Hi,
I have a .dat file with contents like the below:
Input file
============SEQ NO-1: COLUMN1==========
9835619
7152815
============SEQ NO-2: COLUMN2 ==========
7615348
7015548
9373086
============SEQ NO-3: COLUMN3===========
9373086
Expected Output: (I just... (1 Reply)
Hi All ,
We need one help on the below requirement.We have multiple pipe delimited .txt file(around 100 .txt files) present on one directory.We need the total record count of all the files present in that directory without header.File format as below :
... (8 Replies)
Discussion started by: STCET22
8 Replies
LEARN ABOUT PLAN9
dd
DD(1) General Commands Manual DD(1)NAME
dd - convert and copy a file
SYNOPSIS
dd [ option value ] ...
DESCRIPTION
Dd copies the specified input file to the specified output with possible conversions. The standard input and output are used by default.
The input and output block size may be specified to take advantage of raw physical I/O. The options are
-if f Open file f for input.
-of f Open file f for output.
-ibs n Set input block size to n bytes (default 512).
-obs n Set output block size (default 512).
-bs n Set both input and output block size, superseding ibs and obs. If no conversion is specified, preserve the input block size
instead of packing short blocks into the output buffer. This is particularly efficient since no in-core copy need be done.
-cbs n Set conversion buffer size.
-skip n Skip n input records before copying.
-iseek n
Seek n records forward on input file before copying.
-files n
Catenate n input files (useful only for magnetic tape or similar input device).
-oseek n
Seek n records from beginning of output file before copying.
-count n
Copy only n input records.
-conv ascii Convert EBCDIC to ASCII.
ebcdic Convert ASCII to EBCDIC.
ibm Like ebcdic but with a slightly different character map.
block Convert variable length ASCII records to fixed length.
unblock Convert fixed length ASCII records to variable length.
lcase Map alphabetics to lower case.
ucase Map alphabetics to upper case.
swab Swap every pair of bytes.
noerror Do not stop processing on an error.
sync Pad every input record to ibs bytes.
Where sizes are specified, a number of bytes is expected. A number may end with or to specify multiplication by 1024 or 512 respectively;
a pair of numbers may be separated by to indicate a product. Multiple conversions may be specified in the style:
is used only if or conversion is specified. In the first two cases, n characters are copied into the conversion buffer, any specified
character mapping is done, trailing blanks are trimmed and new-line is added before sending the line to the output. In the latter three
cases, characters are read into the conversion buffer and blanks are added to make up an output record of size n. If is unspecified or
zero, the and options convert the character set without changing the block structure of the input file; the and options become a simple
file copy.
SOURCE
/sys/src/cmd/dd.c
SEE ALSO cp(1)DIAGNOSTICS
Dd reports the number of full + partial input and output blocks handled.
DD(1)