04-10-2017
What is the reason for doing this?
Do you want to do this only when + is followed by a single digit 2 in a column; or anytime + is followed by a string whose 1st character is 2.
What have you tried to solve this on your own?
What operating system and shell are you using?
What is the format of your "column" and the file in which it is located?
Please show us a sample input file (in CODE tags) and the corresponding output file (in CODE tags) that you want to produce from that sample input.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
can anyone help me how do i add the colums using awk seperated by character @. for eg i have
3@4
2@9
5@1
the result should be
10 14
i tried using
{ sum+= $1 }
END { print sum }
but it just gives the result 10. can anyone help me with this one
thank you and best regards (7 Replies)
Discussion started by: phone_book
7 Replies
2. Shell Programming and Scripting
Hi,
How to format something like this:
John Roberts 324-141-984 Acct
Jack Williams 159-555-555 Acct
William Jackson 949-911-888 Acct
Mark J Walton 145-852-252 Acct
Fred P Milton 483-244-390 Acct
Bill P J Miller 404-050-223 Acct
into... (12 Replies)
Discussion started by: ora_umair
12 Replies
3. Shell Programming and Scripting
hello
cant find a way to make something like:
awk '{print $1 - $5}' somefile
which is printing $1 $2 $3 $4 $5
should make an array or something? i just dont wanna write $1 $2 $3 $4 $5 to awk input i need to use from $1 to $5 and print them all
and then i need to swith to: from $6 to $10 (3 Replies)
Discussion started by: tip78
3 Replies
4. UNIX for Dummies Questions & Answers
How can I use awk to create a new file that has 2 columns, each colums comes form a different file.
example:
I need column 3 from file1 and column 5 from file2 to make file3. (3 Replies)
Discussion started by: cosmologist
3 Replies
5. Shell Programming and Scripting
I have a data file with 4 columns, of the format:
A1 A2 A3 A4
B1 B2 B3 B4
C1 C2 C3 C4
etc..
I would like to insert to put column 2,3,4 on a new line so my new format would be:
A1
A2 A3 A4
B1
B2 B3 B4
C1
C2 C3 C4
etc.
but am new at using AWK and am not sure how to do it. (5 Replies)
Discussion started by: mikeyd
5 Replies
6. Shell Programming and Scripting
HI ,
I have a comma delimiter file, in which I want to remove 8th and 9th column.
I tried removing those columns using the below code
awk 'BEGIN { FS=","; OFS="," } {$8=$9="";gsub(",+",",",$0)}1' infile
But the problem is 8th and 9th columns are user entered fields, theyvhave carriage... (1 Reply)
Discussion started by: mora
1 Replies
7. Shell Programming and Scripting
Hi experts,
I've used several solutions from this forum to delete nonsense and rearrange data in the project file I'm working on. I'm hoping you guys can give me some tips on further rearranging the data (I've seen a few solutions by searching, but one specific item has me stumped, which is only... (5 Replies)
Discussion started by: coryvp
5 Replies
8. Shell Programming and Scripting
Hi,
I am making a shell script in bash which uses gnuplot to plot the number of road accidents on a certain day, on a certain month. I believe I have the data correct. An example of my data file is here:
cat Day1Accidents.txt
01 13
02 5
03 17
04 8
05 16
06 18
07 12
08 7
09 23
10 12... (2 Replies)
Discussion started by: 06s23
2 Replies
9. Shell Programming and Scripting
Hello everyone
I am a beginner in Shell scripting. Need your help to achieve desired result.
I have a file (sample format below)
001g8aX0007jxLz xxxxxxxxxxxxxxx 9213974926411 CO-COMM-133 CO-L001-DLY 7769995578239 44938 1 1
... (1 Reply)
Discussion started by: Rohit Mallah
1 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I'm trying to copy and paste the sixth column from a bunch of files into a single file having each column pasted in separate columns (and not one after each other in just one column.)
I tried this code but works only partially because it copied and pasted 50 rows of each column... (6 Replies)
Discussion started by: Frastra
6 Replies
LEARN ABOUT XFREE86
neaten
NEATEN(1) General Commands Manual NEATEN(1)
NAME
neaten - neaten up output columns
SYNOPSIS
neaten [ format ]
DESCRIPTION
Neaten reads from its standard input and neatens up columns separated by white space using the specified format. The format is a string
consisting of a positive integer followed by an alignment character and another integer. The alignment character is usually a decimal
point ('.'), but it can be any non-digit.
The alignment character is used as the central point of each column. The total column field width will be the number to the left of the
alignment character plus one for the alignment character itself plus the number to the right of the alignment character.
If a field does not contain the alignment character, it will be printed to the left of where the alignment character would have appeared.
If a field is too long to print within the specified format, the entire field will be printed and that row will not be aligned with the
rest.
The default format is "8.8".
EXAMPLE
To examine a file with columns of numbers:
neaten 10.8 < input | more
BUGS
Columns wider than the total width of the format specification will be printed without any separating white space.
The program does not do anything special with tabs on the input.
AUTHOR
Greg Ward
SEE ALSO
cnt(1), rcalc(1), rlam(1), total(1)
RADIANCE
11/15/93 NEATEN(1)