I want to know how to, given a string like W87151WR71C, if the 4th and 5th character (in this case 15) are greater than 45, then to add 1 to the 3rd character (in this case 7) and assign the revised string the variable name MODSTRING.
Thanks in advance. This is ultimately to grab info from... (6 Replies)
Hi all ,
I have to write a shell script that takes a number as input , like 123
and the output will be 6 ,i.e the output will be the sum of digits of the input.
I have an idea as follows,
echo "123"|fold -1|tr '\n' '+'|bc
But the problem is after " echo "123"|fold -1|tr '\n' '+' "... (5 Replies)
Hi,
I need an awk script (or whatever shell-construct) that would take data like below and get the max value of 3 column, when grouping by the 1st column.
clientname,day-of-month,max-users
-----------------------------------
client1,20120610,5
client2,20120610,2
client3,20120610,7... (3 Replies)
I have a data with 4 columns separete with tab delimiter as following:
A B {123} E{456}
C D {789} T{159}
My expected result as following: (become 5 columns)
A B {123} E {456}
C D {789} T {159}
Is there any way to separate the 4th column to 2 field by using the tab delimiter?
I... (6 Replies)
Hi,
I have a requirement to search for a pattern in each line in a file and remove the in between words till the 3rd occurrence of double quote (").
Ex: CREATE TABLE "SCHEMANAME"."AMS_LTV_STATUS"
(Note: "SCHEMANAME" may changes for different schemas. Its not a fixed value)
I need to... (2 Replies)
Hi experts, I'm looking for a unix solution to replacing "NA" within a matrix with the mean of the column:
$cat file
ID a b c d
day 10 5 100 50
cat 20 6 200 50
dog NA 8 NA 50
car 15 NA NA ... (3 Replies)
This is a file that I have
test line 1 (55)
)
test line 2 (45)
)
I would like to change all the parens in position 1 of this file to a );
i only want to check position 1 in every line of the file. I have tried different varations of sed, but cannot seem to be able to limit it to... (1 Reply)
Hi Friends,
I looked up online, but couldn't figure out a proper solution.
I have an input file where the columns are separated by multiple spaces and the column content is separated by single space.
For example,
Chr1 hello world unix is fun
In the above example, chr1 is first... (3 Replies)
Hi - I have a file "file1" of below format. Its a comma seperated file. Note that each string is enclosed in double quotes.
"abc","-0.15","10,000.00","IJK"
"xyz","1,000.01","1,000,000.50","OPR"
I want the result as:
"abc","-0.15","10000.00","IJK"
"xyz","1,000.01","1000000.50","OPR"
I... (8 Replies)
Hi Experts,
I am new to UNIX. One of my file records are like below
220 IN C/A 515013 NULL NULL
220 IN C/A 515017 NULL NULL
225 IN C/A 333701 NULL NULL
225 IN C/A 515034 NULL NULL
225 IN C/A 499201 NULL NULL
225 IN C/A 499202 NULL NULL
The above mentioned records delimiter is... (4 Replies)
Discussion started by: suresh_target
4 Replies
LEARN ABOUT POSIX
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)