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 DEBIAN
language::intercal::charset::ebcdic
INTERCAL::Charset::EBCDIC(3pm) User Contributed Perl Documentation INTERCAL::Charset::EBCDIC(3pm)NAME
Charset::EBCDIC - allows to use EBCDIC string constants in ASCII programs (and v.v.)
SYNOPSIS
use Charset::EBCDIC 'ascii2abcdic';
my $a = ebcdic2ascii "(EBCDIC text)";
DESCRIPTION
Charset::EBCDIC defines functions to convert between a subset of ASCII and a subset of nonstandard EBCDIC (since there isn't such a thing
as a standard EBCDIC we defined our own variant which is guaranteed to be incompatible with all versions of EBCDIC used by IBM hardware -
however, when we have chosen a code for a character, we have made sure that at least one - but certainly not all - IBM models used that
same code, so the choice cannot be criticised). If you really want to know, several variants of EBCDIC are listed in RFC 1345, which is
available from the usual sources.
Two functions, ebcdic2ascii and ascii2ebcdic are exportable but not exported by default. They do the obvious thing to their first argument
and return the transformed string.
EBCDIC CHARACTER TABLE
The following are the characters recognised. The ones shown as 2 letter abbreviations cannot be translated to ASCII (except for the control
characters, which do have an ASCII equivalent).
+ 0 1 2 3 4 5 6 7 8 9 a b c d e f Notes
00 OV TA LF CR OV=overstrike
10 TA=tab
20 LF=linefeed
30 CR=carr-return
40 SP CT . < ( + ! SP=space
50 & ] $ * ) ; NO CT=cents
60 - / XO | , % _ > ? NO=not-sign
70 : # @ ' = " XO=XOR(1)
80 a b c d e f g h i
90 j k l m n o p q r { [
a0 ~ s t u v w x y z RE RE=registered
b0 ^ PO CO PO=pound
c0 A B C D E F G H I CO=copyright
d0 J K L M N O P Q R }
e0 S T U V W X Y Z
f0 0 1 2 3 4 5 6 7 8 9 DE DE=delete(1) The symbol for the INTECAL XOR operator, "V overstrike -".
COPYRIGHT
This module is part of CLC-INTERCAL.
Copyright (C) 1999, 2000, 2002, 2006, 2007 Claudio Calvelli, all rights reserved
See the files README and COPYING in the distribution for information.
SEE ALSO
A qualified psychiatrist.
perl v5.8.8 2008-03-29 INTERCAL::Charset::EBCDIC(3pm)