# Extract the second column of input.tab
awk '\t'{print $2}' input.tab > input.temp
# Find ID from input.temp in table.tab
grep -wf input.temp table.tab > output.temp
# Extract the second field of the extracted line from output.temp
awk '\t'{print$2}' output.temp
but after to re-stick everything together in the right order is messy !
(in the final output.tab, the IDs can be separated by a coma "," but it is totally optional)
while read a b; do sed -i "s/$a/$b/g" input.tab ; done < table.tab
It returns:
Code:
sed: 1: "input.tab": command i expects \ followed by text
sed: 1: "input.tab": command i expects \ followed by text
sed: 1: "input.tab": command i expects \ followed by text
sed: 1: "input.tab": command i expects \ followed by text
sed: 1: "input.tab": command i expects \ followed by text
sed: 1: "input.tab": command i expects \ followed by text
sed: 1: "input.tab": command i expects \ followed by text
sed: 1: "input.tab": command i expects \ followed by text
1) take backup of input.tab file
cp input.tab input.tab.20120223
2) To modifiy
while read a b; do sed "s/$a/$b/g" input.tab > output.tab; mv output.tab input.tab; done < table.tab
I have text with upper and lower case words. I want to find something and replace it with something new. But it should match the case - Meaning - it should replace old upper cased word with NEW upper case word and lower with lower.
example:
this text is very simple TEXT.
now I want to replace... (5 Replies)
Hi
I am looking to rename the contents of this dir, each one with a new timestamp, interval of a second for each so it the existing format is on lhs and what I want is to rename each of these to what is on rhs..hopefully it nake sense
CDR.20060505.150006.gb CDR.20121211.191500.gb... (3 Replies)
I have a flat file (template) where I want to replace variables based upon a value in another file (csv).
The variables in the template are named %VAR_X_z%
The values are in the csv file and X is field 0 of each line and y field 1 and up.
Example of the csv:
Badidas, 13.00, 12.00, 11.00,... (8 Replies)
Hi All,
I have a unix shell script file as below.
My task is
a)to replace 248 to 350 and need to create a new file as BW3_350.sh
b)to replace 248 to 380 and need to create a new file as BW3_380.sh
c)to replace 248 to 320 and need to create a new file as BW3_320.sh
there is no... (6 Replies)
Hello,
I often have this problem:
I have a file with a column of unique identifiers
e.g. file1 below has an id column and data column/columns with p rows:
cat data1
dog data2
cow data3
.
.
.
elephant datap-1
horse datap
and I have a conversion file,file2, with n<p rows... (4 Replies)
find . -type f -name "*.sql" -print|xargs perl -i -pe 's/pattern/replaced/g'
this is simple logic to find and replace in multiple files & folders
Hope this helps.
Thanks
Zaheer (0 Replies)
Is this something SED would be used for or can AWK do it?
I have a string that I would like to chop bits out of and re-arrange some of the rest.
Basically I want to change this:
<log4j:event logger="webserver" timestamp="1240110840109" time="Sun Apr 19 04:14:00 BST 2009" level="INFO"... (4 Replies)
Looking for a way using sed/awk/perl to replace port numbers in a file with an incrementing number. The original file looks like...
Host cmg-iqdrw3p4
LocalForward *:9043 localhost:9043
Host cmg-iqdro3p3a
LocalForward *:10000 localhost:10000
Host cmg-iqdro3p3b
LocalForward... (2 Replies)
Hi all,
I have a script that scan files, find old templet and replace it with new one.
#!/bin/ksh
file_name=$1
old_templet=$2
new_templet=$3
# Loop through every file like this
for file in file_name
do
cat $file | sed "s/old_templet/new_templet/g" > $file.new
#do a global searce and... (8 Replies)
I get a text file with 70+ columns (seperated by Tab) and about 10000 rows. The 58th Column is all numbers. But sometimes 58th columns has "/xxx=##" after the numeric data. I want to truncate this string using the script. Any Ideas...:confused: (3 Replies)
