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 CENTOS
sa1
SA1(8) Linux User's Manual SA1(8)NAME
sa1 - Collect and store binary data in the system activity daily data file.
SYNOPSIS
/usr/lib64/sa/sa1 [ --boot | interval count ]
DESCRIPTION
The sa1 command is a shell procedure variant of the sadc command and handles all of the flags and parameters of that command. The sa1 com-
mand collects and stores binary data in the /var/log/sa/sadd file, where the dd parameter indicates the current day. The interval and count
parameters specify that the record should be written count times at interval seconds. If no arguments are given to sa1 then a single record
is written.
The sa1 command is designed to be started automatically by the cron command.
OPTIONS --boot This option tells sa1 that the sadc command should be called without specifying the interval and count parameters in order to insert
a dummy record, marking the time when the counters restarts from 0.
EXAMPLE
To collect data (including those from disks) every 10 minutes, place the following entry in your root crontab file:
0,10,20,30,40,50 * * * * /usr/lib64/sa/sa1 1 1 -S DISK
FILES
/var/log/sa/sadd
Indicate the daily data file, where the dd parameter is a number representing the day of the month.
AUTHOR
Sebastien Godard (sysstat <at> orange.fr)
SEE ALSO sar(1), sadc(8), sa2(8), sadf(1), sysstat(5)
http://pagesperso-orange.fr/sebastien.godard/
Linux FEBRUARY 2012 SA1(8)