Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

sed replace values of column with ordered numbering

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sed replace values of column with ordered numbering
# 1  
Old 06-11-2011
sed replace values of column with ordered numbering
Hello,

I am trying to write a shell script that will create a gnuplot file.

My main problem is that I have a data file with two columns:

1.05929120E+09 5.0000701214792
1.05930096E+09 5.00006386985764
1.05930584E+09 5.00019465404908
1.05931072E+09 5.00031960589719
1.05931559E+09 5.00040271630384
1.05932047E+09 5.00020010067377
1.05932535E+09 5.00039493212858
1.05933023E+09 5.00052596491601
1.05933511E+09 5.0006511754308
1.05933998E+09 5.00073406230015

I need column 1 to be displayed like this in the script that will generate the gnuplot file:

Code:
cat > Script.sh <<-__EOF__
#!$MyGnuplot -persist
set title "Title"
set xlabel "X axis"
set ylabel "Y axis"
set mxtics 5
set mytics 5
unset label

set xrange [0:7e+09]
set yrange [0:0.12]
set parametric
set trange [0:0.12]

const1=1.05929120E+09
const2=1.05930096E+09
const3=1.05930584E+09
.
.
.
const10=1.05933998E+09
plot\\
'./elements.dat' u 1:2 w l\\
const1,t\\
const2,t\\
const3,t\\
.
.
.
const10,t
set terminal x11
__EOF__

I.e. I need to tr '\n' ' ' the first column of data but adding a consti= in front of it
running from i=1 .... last_number

I have never been good at looping...

Any help will be appreciated.

Thanks
# 2  
Old 06-11-2011
what is the desired output?
# 3  
Old 06-11-2011
Maybe this can help:
Code:
% cat testfile
1.05929120E+09 5.0000701214792
1.05930096E+09 5.00006386985764
1.05930584E+09 5.00019465404908
1.05931072E+09 5.00031960589719
1.05931559E+09 5.00040271630384
1.05932047E+09 5.00020010067377
1.05932535E+09 5.00039493212858
1.05933023E+09 5.00052596491601
1.05933511E+09 5.0006511754308
1.05933998E+09 5.00073406230015

% var=`while read a b; do
  count=$(($count + 1))
  echo "const$count=$a"
done < testfile`

% cat  <<EOF           
$var
EOF
const1=1.05929120E+09
const2=1.05930096E+09
const3=1.05930584E+09
const4=1.05931072E+09
const5=1.05931559E+09
const6=1.05932047E+09
const7=1.05932535E+09
const8=1.05933023E+09
const9=1.05933511E+09
const10=1.05933998E+09

but awk is better:
Code:
% awk '{print "const" ++count "=" $1}' testfile

Last edited by yazu; 06-11-2011 at 09:16 AM.. Reason: awk is better
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Replace a numeric values in a certain column

Hi All, I am trying to replace a certain value from one place in a file . In the below file at position 35 I will have 8 I need to modify all 8 in that position to 7 I tried awk '{gsub("8","7",$35)}1' infile > outfile ----> not working sed -i 's/8/7'g' infile --- it is replacing all... (3 Replies)
Discussion started by: arunkumar_mca
3 Replies

2. Shell Programming and Scripting

Trying to get an awk script to replace values in column

I'm trying to make an awk script to compare values I've set as var1, var2, and var3 earlier in the script to the values in the userinputted column of four text files called Node1.txt, Node2.txt, Node3.txt, and Node4.txt and then replace the values in that userinputted column with either ttt or gcc,... (8 Replies)
Discussion started by: Eric1
8 Replies

3. UNIX for Dummies Questions & Answers

Replace all decimal values in a column

Hi My input file looks String000002 GeneWise CW 48945 49354 . - 0 Pt=PEQU_00004; String000002 LEN NA 52125 52604 0.945751 - . PID=PEQU_00005;lvid_id=PEQ_28708; String000002 LEN CW 52125 52604 . - 0 ... (3 Replies)
Discussion started by: siya@
3 Replies

4. Shell Programming and Scripting

Replace column values from other file

I have one file as it has the following format File1 S No Site IP Address 1 Australia 192.168.0.1/26 2 Australia 192.168.0.2/26 3 Australia 192.168.0.3/26 I need awk/sed command to replace the column2 value ( under Site) with some other... (8 Replies)
Discussion started by: samaritan
8 Replies

5. Shell Programming and Scripting

Selective Replace awk column values

Hi, I have the following data: 2860377|"DATA1"|"DATA2"|"65343"|"DATA2"|"DATA4"|"11"|"DATA5"|"DATA6"|"65343"|"DATA7"|"0"|"8"|"1"|"NEGATIVE" 32340377|"DATA1"|"DATA2"|"65343"|"DATA2"|"DATA4"|"11"|"DATA5"|"DATA6"|"65343"|"DATA7"|"0"|"8"|"1"|"NEG-DID"... (3 Replies)
Discussion started by: sdohn
3 Replies

6. UNIX for Dummies Questions & Answers

replace a column with values from another file

Dear all, I have a file1.pdb in pdb format and a dat file2 containing values, corresponding to the atoms in the pdb file. these values (file2.dat) need to be in the column instead of the 0.00 (file1) values for each atom in file1.pdb .(the red values must be replaced by the blue ones,in order)... (11 Replies)
Discussion started by: chen.xiao.po
11 Replies

7. UNIX for Dummies Questions & Answers

Replace values in a specified column of a file

Hello, I have a file with four columns and I would like to replace values in the second column only. An arbitrary example is: 100 A 105 B 200 B 205 C 300 C 305 D 400 D 405 E 500 E 505 F I need to replace the second column as shown below: ... (4 Replies)
Discussion started by: Gussifinknottle
4 Replies

8. Shell Programming and Scripting

awk/sed column replace using column header - help

$ cat log.txt Name Age Sex Lcation nfld alias xsd CC 25 M XYZ asx KK Y BB 21 F XAS awe SS N SD 21 M AQW rty SD A How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column? so that the final output will become: Name Age Sex... (10 Replies)
Discussion started by: jkl_jkl
10 Replies

9. Shell Programming and Scripting

replace the column values.

I have the below file ...where some of the column values should replaced with desired values ....below file u can find that 3 column where ever 'AAA' comes should replaced with ' CC ' NOTE : we have to pass the column number ,AAA,CC (modified value) as the parameters to the code. ... (6 Replies)
Discussion started by: charandevu
6 Replies

10. UNIX for Advanced & Expert Users

replace a column values with the first value in column

Hi All, I have a file which has data in following format: "Body_Model","2/1/2007","2/1/2007" "CSCH74","0","61" "CSCS74","0","647" "CSCX74","0","3" "CSYH74","0","299" "CSYS74","0","2514" "CSYX74","0","3" "Body_Model","3/1/2007","3/1/2007" "CSCH74","0","88" "CSCS74","0","489"... (3 Replies)
Discussion started by: sumeet
3 Replies
Login or Register to Ask a Question