Count on grep for more than two values in a row of fixed length file
I want to get count on number of records in a few folders by running grep command for more than two columns in a row of fixed length file.
suppose if i have a fixed length file has 5 columns and I want to see the record counts for country =can and province = bc and time stamp <= 12 feb 2013 00:00:00 to 13 feb 2013 00:00:00 ? how do I do that?
The above query should return me
can you please give the script or command to accomplish this query? if possible to output to a file?
thanks,
Moderator's Comments:
Please use code tags when posting data and code samples!
Last edited by vgersh99; 02-13-2013 at 05:52 PM..
Reason: code tags, please!
Is there a command that sets a variable length?
I have a input of a variable length field but my output for that field needs to be set to 32 char.
Is there such a command?
I am on a sun box running ksh
Thanks (2 Replies)
Newbie
Looking for a script to convert my input file to delimited text file. Not familier with AWK or shell programing. Below is sample record in my input file and the expected output format. My OS is HPUX 11.23.
Thanks in advance for your assistance.
tbtbs
input file:... (12 Replies)
Hi, all.
I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file:
10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783
19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657
And this is the expected... (2 Replies)
hi
i have two types of file
1. temp.0000000001.data (10 digit numeric)
2. temp.000000001.data (9 digit numeric)
i want to search a file which is having 10 digit numeric in between the file name.
i use command like this..
ls | grep temp.^*.data
but this will give both the files as... (2 Replies)
Hi,
I have a fixed length file where I need to verify the values of 3 different fields, where each field will have a different value.
How can I do that in a single step. (6 Replies)
How do I extract values in a few columns in a row of a fixed length file?
If there are 8 columns and I need to extract values of 2nd,4th and 6 th columns, how do i do that? I used cut command, this I used only for one column. How do I do it more than one column?
The below command will give... (1 Reply)
I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers.
awk '{print length;exit}' <File_name>
The above code gives me length 50.
wc -L <File_name>
The above code gives me length 53.
Please clarify on... (2 Replies)
Hi,
I have a DB2 UDB 9.7 SQL script, as follows:
I need to pass the script into Unix and generate a fixed length file from this.
Can someone kindly provide a script to achieve it?
SELECT
CAST(COALESCE(CL_ID,'000000000') AS CHAR(9)) AS CL_ID
,STATUS... (5 Replies)
I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv
abc.csv-
UTF-8,,,,,,,,,,,,,,,,,,,,,,,,,
... (6 Replies)
Discussion started by: Tahir_M
6 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)