01-07-2010
Thanks for your reaction radoulov. As a matter of fact I saw this morning in one of our production servers that yesterday's command only worked in some files.
I'm using substr insted of index in your awk command and for now it seems it's working properly, I'll come back to you if I have other problem.
Many thanks for your help!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Guys...
I am newbie to awk and would like a solution to probably one of the simple practical questions.
I have a test file that goes as:
1,2,3,4,5,6
7,2,3,8,7,6
9,3,5,6,7,3
8,3,1,1,1,1
4,4,2,2,2,2
I would like to know how AWK can get me the distinct values say for eg: on col2... (22 Replies)
Discussion started by: anduzzi
22 Replies
2. Shell Programming and Scripting
I want to remove text from nth position to nth position couple of times in same line
my line is
"hello is there anyone can help me with this question"
I need like this
ello is there anyone can help me with question
'h' is removed and 'this' removed from the line. I want to do this... (5 Replies)
Discussion started by: elamurugu
5 Replies
3. Shell Programming and Scripting
Hi
I'm looking for a way to read a text file that may contain 1000 records or more and each of these records has 460 characters. I need to read each record, and add a string of characters starting at position 256 for each record. Any suggestions using UNIX shell scripting. (4 Replies)
Discussion started by: macastor
4 Replies
4. UNIX for Advanced & Expert Users
Hello everyone,
I am writing a script to process data from the ATP world tour.
I have a file which contains:
t=540 y=2011 r=1 p=N409
t=540 y=2011 r=2 p=N409
t=540 y=2011 r=3 p=N409
t=540 y=2011 r=4 p=N409
t=520 y=2011 r=1 p=N409
t=520 y=2011 r=2 p=N409
t=520 y=2011 r=3 p=N409
The... (4 Replies)
Discussion started by: imahmoud
4 Replies
5. Shell Programming and Scripting
Hi
My file have 7 column, FIle is pipe delimed
Col1|Col2|col3|Col4|col5|Col6|Col7
I want to find out uniq record count on col3, col4 and col2 ( same order) how can I achieve it.
ex
1|3|A|V|C|1|1
1|3|A|V|C|1|1
1|4|A|V|C|1|1
Output should be
FREQ|A|V|3|2
FREQ|A|V|4|1
Here... (5 Replies)
Discussion started by: sanranad
5 Replies
6. Shell Programming and Scripting
Hi experts,
Need your help on how to insert carriage return after the 10th char position of each line in a file and then add two blank spaces after the carriage return.
Example:
>cat test.txt
testingline
dummystring
samplesample
teststringline
Expected output should be..
... (2 Replies)
Discussion started by: brichigo
2 Replies
7. Shell Programming and Scripting
Hello,
I have some tab delimited data and I need to move the last col. I could hard code it,
awk '{ print $1,$NF,$2,$3,$4,etc }' infile > outfile
but it would be nice to know the syntax to print a range cols.
I know in cut you can do,
cut -f 1,4-8,11-
to print fields 1,... (8 Replies)
Discussion started by: LMHmedchem
8 Replies
8. Shell Programming and Scripting
Hi,
Please help with this.
I have several excel files (with and .xlsx format) with 10-15 columns each.
They all have the same type of data but the columns are not ordered in the same way.
Here is a 3 column example. What I want to do add the alphabet
from column 2 to column 3, provided... (9 Replies)
Discussion started by: newbie83
9 Replies
9. Shell Programming and Scripting
Hi,
Please help, this is quite complex, I dont know how to start.
The original input files are 10mb in size each.
I have multiple files and I want to merge them in the following way.
Every file has 4 columns. Col1 and col2 are fixed with respect to each other. In the example value A... (2 Replies)
Discussion started by: alpesh
2 Replies
10. Shell Programming and Scripting
Hi,
i was tried using the awk command for replacing '-' in the second column. but the below command replacing the entire file.
cat 1.txt |awk '{gsub(/-/,"")}1'
Input file
1,2,3,-4,5,6
1,-2,3,4,5,-6
1,2,3,4,5,6
1,-2,3,4,-5,6
Output file
1,2,3,-4,5,6
1,2,3,4,5,-6
1,2,3,4,5,6... (3 Replies)
Discussion started by: onesuri
3 Replies
LEARN ABOUT SUNOS
aset.restore
aset.restore(1M) System Administration Commands aset.restore(1M)
NAME
aset.restore - restores system files to their content before ASET is installed
SYNOPSIS
aset.restore [-d aset_dir]
DESCRIPTION
aset.restore restores system files that are affected by the Automated Security Enhancement Tool (ASET) to their pre-ASET content. When ASET
is executed for the first time, it saves and archives the original system files in the /usr/aset/archives directory. The aset.restore
utility reinstates these files. It also deschedules ASET, if it is currently scheduled for periodic execution. See asetenv(4).
If you have made changes to system files after running ASET, these changes are lost when you run aset.restore. If you want to be abso-
lutely sure that you keep the existing system state, it is recommended that you back-up your system before using aset.restore.
You should use aset.restore, under the following circumstances:
You want to remove ASET permanently and restore the original system (if you want to deactivate ASET, you can remove it from schedul-
ing).
You are unfamiliar with ASET and want to experiment with it. You can use aset.restore to restore the original system state.
When some major system functionality is not working properly and you suspect that ASET is causing the problem; you may want to
restore the system to see if the problem persists without ASET.
aset.restore requires root privileges to execute.
OPTIONS
The following options are supported:
-d aset_dir Specify the working directory for ASET. By default, this directory is /usr/aset. With this option the archives directory
will be located under aset_dir.
FILES
/usr/aset/archives archive of system files prior to executing aset
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWast |
+-----------------------------+-----------------------------+
SEE ALSO
aset(1M), asetenv(4), attributes(5)
System Administration Guide: Basic Administration
SunOS 5.10 11 Oct 1991 aset.restore(1M)