Hi Friends,
Can anyone guide me how to compute sum of column4 from the below file x using awk command? when i do using awk I'm getting sum 7482350198352648.000000 which is not accurate.
$ cat x
56,232,dfgjkhdfj,,56,anand
56,22,dfgjkhdfj,7482347823453123.97834 ,56,Khan
56,23,dfgjkhdfj, ... (6 Replies)
Hi,
Does anyone know a easy way to printf $3,$4, ... all the way to the last field in the file? I will need to modify $1 and $2 and then printf modified $1 and $2 and the rest of the fields(which are not changed).
I know I can use NF as the total number of field.
Do I use a for next statement to... (4 Replies)
Hi,
I've got a basic problem using printf statement in awk.
I want to write float values with always 8 characters width.
Examples :
1.345678
12.45678
123.4567
1234.678
-23.5678
-2.45678
-23456.8
.....
I cannot find the right printf format %8.1f, %7.5f....
Can anyone help ?... (4 Replies)
Hi friends..
I am confused about awk printf option..
I have a comma separated file
88562848,21-JAN-08,2741079, -1188,-7433,TESTING
88558314,21-JAN-08,2741189, -1273,-7976,TESTING
and there is a line in my script ( written by someone else)
What is the use of command?
I guess... (10 Replies)
Target file contains short text (never more than 1 line) and filenames.
The format is, e.g.,:
TEXT1
filename1
TEXT2
TEXT3
filename3dddd
filename3dddd
TEXT4
filename4
TEXT5
filename5dddd
filename5dddd
filename5
where dddd is a random 4-digit whole number.
Desired output: (4 Replies)
Hi,
I am using the following code to assign a count value to a variable. But I get nothing. Do you see anything wrong here.
I am new to all this.
$CTR=`remsh $m -l $MACHINES{$m} -n cat $output | grep -v sent | grep \"$input\" | sort -u | awk '{print $5}'`;
Upto sort - u it's... (2 Replies)
Hello
Here is an easy one
Data file
12345 (tab) Some text (tab) 53.432
23456 (tab) Some longer text (tab) 933.422
34567 (tab) Some different text (tab) 29.309
I need to awk these three tab-delimited columns so that the first two are unchanged (unformatted) and the third shows two decimal... (1 Reply)
I have a very large file with more than 500,000 lines of dated events.
The first field contains the date/time in the following format:
20120727-files.files:20120727090044
where the first 8 numbers represent yyyymmdd. The last set of numbers represent yyyy/mm/dd/hh:mm:ss
I would like to... (4 Replies)
Please help me format this file:
Source file looks like this, there are three columns, separated by space. First column has varrying width:
1 248105240 W25_2013
10 248103710 W06_2013
100 248103710 W06_2013
1000 248103710 W06_2013
I need to transform the file into a fixed width per column.... (1 Reply)
Discussion started by: tamahomekarasu
1 Replies
LEARN ABOUT PHP
iconv_substr
ICONV_SUBSTR(3) 1 ICONV_SUBSTR(3)iconv_substr - Cut out part of a stringSYNOPSIS
string iconv_substr (string $str, int $offset, [int $length = iconv_strlen($str, $charset)], [string $charset = ini_get("iconv.inter-
nal_encoding")])
DESCRIPTION
Cuts a portion of $str specified by the $offset and $length parameters.
PARAMETERS
o $str
- The original string.
o $offset
- If $offset is non-negative, iconv_substr(3) cuts the portion out of $str beginning at $offset'th character, counting from zero.
If $offset is negative, iconv_substr(3) cuts out the portion beginning at the position, $offset characters away from the end of
$str.
o $length
- If $length is given and is positive, the return value will contain at most $length characters of the portion that begins at
$offset (depending on the length of $string). If negative $length is passed, iconv_substr(3) cuts the portion out of $str from
the $offset'th character up to the character that is $length characters away from the end of the string. In case $offset is also
negative, the start position is calculated beforehand according to the rule explained above.
o $charset
- If $charset parameter is omitted, $string are assumed to be encoded in iconv.internal_encoding. Note that $offset and $length
parameters are always deemed to represent offsets that are calculated on the basis of the character set determined by $charset,
whilst the counterpart substr(3) always takes these for byte offsets.
RETURN VALUES
Returns the portion of $str specified by the $offset and $length parameters.
If $str is shorter than $offset characters long, FALSE will be returned.
SEE ALSO substr(3), mb_substr(3), mb_strcut(3).
PHP Documentation Group ICONV_SUBSTR(3)