04-11-2008
Because i am having 10,000 rows and 50 columns .....not only mensioned column so many columns have to converted ....
I have to pass column no and conversion value and converted value ...as parameters to the code ........kindly help ........it is little urgent ....
earlier iam are using below it is not working ...can u help me please ..because on column may have different conversion values ....
awk 'BEGIN { FS=OFS=","}$5=="E001"{ $5="sath"}$6=="E000"{ $6="SSAA"}1' mass > mass1
Last edited by satyam_sat; 04-11-2008 at 02:48 AM..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi guys,
I have one file with duplicate string. I want to replace all the occurance of that string with some other string.
How can I do that in vi editor?
Malay Maru (3 Replies)
Discussion started by: malaymaru
3 Replies
2. Shell Programming and Scripting
Hi All,
As I'm working on a Unix script...
and the requirement is like, I need to search a word and replace it with the another word...
for that i'm using SED command....
can anybody give any other alternate for this...?
Thanks
Amit (2 Replies)
Discussion started by: Amits
2 Replies
3. UNIX for Advanced & Expert Users
I have a file (say file1.txt) and I have to search for a line which has a text replace it and replace another string too in the same line.
Eg:
file1.txt
--------
x='hai' y='world' z='unix'
x='hai'
y='world'
x='hai' z='perl' y='world' z="world" k="junk" b="world"
z='perl' x='hai'... (3 Replies)
Discussion started by: ammu
3 Replies
4. Shell Programming and Scripting
Hi all,
The operating system is Solaris 10
I have example line here below I need to change the stat1 to stat2 using a shell script. search for space(" ") and replace with "\ "
Stat1 --- /data/Sat Night Stay.txt
Stat2 --- /data/Sat\ Night\ Stay.txt
Thanks
Firestar. (1 Reply)
Discussion started by: firestar
1 Replies
5. Shell Programming and Scripting
Hi Experts,
I had to edit (a particular value) in header line of a very huge file so for that i wanted to search & replace a particular value on a file which was of 24 GB in Size. I managed to do it but it took long time to complete. Can anyone please tell me how can we do it in a optimised... (7 Replies)
Discussion started by: manishkomar007
7 Replies
6. Emergency UNIX and Linux Support
Hi,
I have gigabytes of text files that I need to search for "&" and replace with "&". Is there a way to do this efficiently (like sed command)?
Hope you could help.
Thanks. (17 Replies)
Discussion started by: daytripper1021
17 Replies
7. Shell Programming and Scripting
I have file t1.log
Contents of t1.log file
Number of records processed:
Number of records rejected:
Error :
xyz ..........
abc ..........
aaa _]
start time :
end time :
Please let me know how i can remove the contents highlighted in red in the t1.log file.
Thanks
Sam (3 Replies)
Discussion started by: sam777
3 Replies
8. Shell Programming and Scripting
Hi Team,
I am new to unix, please help me in this.
I have a file named properties.
The content of the file is :
##Mobile props
east.url=https://qa.east.corp.com/prop/end
west.url=https://qa.west.corp.com/prop/end
south.url=https://qa.south.corp.com/prop/end... (2 Replies)
Discussion started by: tolearn
2 Replies
9. Shell Programming and Scripting
Hi,
more data.txt
more srstring.sh
input="data.txt"
while IFS= read -r var
do
startdirectory=$loc
search=$(echo $var | awk -F'=' '{print $1}')
replace=$(echo $var | awk -F'=' '{print $2}')
find "/tmp/config" -type f -exec grep -l "$search" {} + |
while read file
do if sed -e... (9 Replies)
Discussion started by: mohtashims
9 Replies
10. Shell Programming and Scripting
hi All
i'm new to shell/bash scripting and need help to write a script.
question: i have a file of 100's of line, i need to replace all zeros in that file with its respective position, starting from 0 to 23 and remove the remaining
sample file is like.
Enter the date in the format... (12 Replies)
Discussion started by: sunnu2u86
12 Replies
LEARN ABOUT NETBSD
column
COLUMN(1) BSD General Commands Manual COLUMN(1)
NAME
column -- columnate lists
SYNOPSIS
column [-tx] [-c columns] [-s sep] [file ...]
DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file operands, or, by
default, from the standard input. Empty lines are ignored.
The options are as follows:
-c Output is formatted for a display columns wide.
-s Specify a set of characters to be used to delimit columns for the -t option.
-t Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with
the characters supplied using the -s option. Useful for pretty-printing displays.
-x Fill columns before filling rows.
column exits 0 on success, >0 if an error occurred.
ENVIRONMENT
COLUMNS The environment variable COLUMNS is used to determine the size of the screen if no other information is available.
EXAMPLES
(echo "PERM LINKS OWNER GROUP SIZE MONTH DAY HH:MM/YEAR NAME";
ls -l | sed 1d) | column -t
SEE ALSO
colrm(1), ls(1), paste(1), sort(1)
HISTORY
The column command appeared in 4.3BSD-Reno.
BSD
March 9, 2008 BSD