Regarding the rest of your question, if it's always the case that you wish the commas were semi-colons in your new file, you could translate prior to your awk:
Keep in mind now your field 4 will be 4&5 and your field 5 will be 6&7 and on down the line. Here's your data and field numbers now:
If you don't want to unilaterally translate, i.e., some OTHER fields might have imbedded commas that you don't want to translate to semicolon, use the split feature on fields 4 & 5 like so:
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,
Scripting newb here. So I'm trying to create a geektool script that uses awk and printf to output certain fields from top (namely command, cpu%, rsize, pid and time, in that order). After much trial and error, I've pretty much succeeded, with one exception. Any process whose name... (3 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 SUSE
translate
TRANSLATE(1) General Commands Manual TRANSLATE(1)NAME
translate - looks up for words in a dictionary
SYNOPSIS
translate [options] words
DESCRIPTION
translate looks up for words in a dictionary and translates them. It can handle multiple dictionaries and charsets. It comes with an eng-
lish-german dictionary and is able to translate in both directions.
OPTIONS -n non-interactive (don't prompt if no matches found)
-i invers lookup (from second to first language)
-l languages to translate between
-v display version and exit
-w searches only whole words
-h display help
EXAMPLE
translate -l en-de simplest
SEE ALSO
xtranslate
FILES
translate preferred language and is stored in /etc/translate.conf You can store your private configuration file in ~/.translate. If there
are no options in the commandline it uses the default values de-en.
It can also create a private dictionary in ~/.translate
AUTHOR
Jochem Huhmann <jochem@revier.com> wrote translate. This manual page was written for the Debian GNU/Linux system (but may be used by oth-
ers).
TRANSLATE(1)