This awk script seems to do what you want:
It was tested with the file varnw1 containing:
but you could put each value on a different line or all values on a single line. I added three additional zeros to the end of the value shown in red so you can see what happens when the number of digits after the decimal point in a value in this file is larger than the corresponding value in file1 and the numeric values of the two numbers are different.
When file1 contains:
the following will be written to file2:
with the only two lines changed by the script marked in red. You will note that when the value in both files had 5 digits after the decimal point, the difference is shown with 5 digits after the decimal point and when the value in the 1st file had 8 digits after the decimal point and the value in the 2nd file had 5 digits after the decimal point, the difference is shown with 8 digits after the decimal point. The number of digits printed is determined by the value returned by the dpm() (decimal point max) function
I hope the comments I added to the script will enable you to figure out what it is doing. If it doesn't ask questions.
This awk script seems to do what you want:
It was tested with the file varnw1 containing:
but you could put each value on a different line or all values on a single line. I added three additional zeros to the end of the value shown in red so you can see what happens when the number of digits after the decimal point in a value in this file is larger than the corresponding value in file1 and the numeric values of the two numbers are different.
When file1 contains:
the following will be written to file2:
with the only two lines changed by the script marked in red. You will note that when the value in both files had 5 digits after the decimal point, the difference is shown with 5 digits after the decimal point and when the value in the 1st file had 8 digits after the decimal point and the value in the 2nd file had 5 digits after the decimal point, the difference is shown with 8 digits after the decimal point. The number of digits printed is determined by the value returned by the dpm() (decimal point max) function
I hope the comments I added to the script will enable you to figure out what it is doing. If it doesn't ask questions.
Don, thanks for your reply, I haved tested it and the result it`s ok for the script but the values are wrong.
The original value #23 2.73300 it`s operated with 2.73230 equals +0.00070
same with the #24 with must be +0.00070000
It is interesting to note that if we put the values:
in varnw1 (the values shown in the current version of the 1st message in this thread) and we put the sample data from that message in file1, the results my script puts in file2 is:
which matches what you said you wanted in that message.
If you decided to switch the order of the operands in the subtraction in your calculations and didn't bother telling us that you had done so, it is not a bug in the script! If want to change your requirements again, have the courage to say that you want me to change the script again to meet your new requirements. Don't tell me there is a bug in my script when it behaves exactly as you said it should behave.
I gave you a fully commented script that tried to explain each action it was taking. Can you guess which single line in my script needs to change to meet your new requirements?
It is interesting to note that if we put the values:
in varnw1 (the values shown in the current version of the 1st message in this thread) and we put the sample data from that message in file1, the results my script puts in file2 is:
which matches what you said you wanted in that message.
Don, you are right here again,the script meet with the requirment of the first message in this thread.
Quote:
If you decided to switch the order of the operands in the subtraction in your calculations and didn't bother telling us that you had done so, it is not a bug in the script! If want to change your requirements again, have the courage to say that you want me to change the script again to meet your new requirements. Don't tell me there is a bug in my script when it behaves exactly as you said it should behave.
I haved noted this in the last run of the script, I appreciate your help so do not be mad.
Quote:
I gave you a fully commented script that tried to explain each action it was taking.
Thanks a lot for that... im understanding a bit more now.. but I still haven`t the knowgledge to make changes.
Quote:
Can you guess which single line in my script needs to change to meet your new requirements?
I gave you a fully commented script that tried to explain each action it was taking. Can you guess which single line in my script needs to change to meet your new requirements?
I haved test replacing in the script:
for
It`s right?
@faka
It's also worth if you click 'thank' button in right side, for useful post, if your requirement is keep on changing or real input is other than sample input you provided, obviously our code will not work, it doesn't mean that bug in code. Please be more specific about requirement while posting a thread, I personally feel it just kills time of person who comes here to help, and also please note that here all are hard working volunteers, please give importance to their time also.
Hi friends,
i need a command which can be used to change the values in file.
I have file which contain some values.
Data_Center_costing=XXXX
Financial_loss=XXXX
operational_cost=XXX
I am not aware about the values of XXXX, They may be 4 digit or less/more than that. but i need these... (12 Replies)
Hi again. Sorry for all the questions — I've tried to do all this myself but I'm just not good enough yet, and the help I've received so far from bartus11 has been absolutely invaluable. Hopefully this will be the last bit of file manipulation I need to do.
I have a file which is formatted as... (4 Replies)
I have a bunch of file numbers in the file 'test':
I'm trying the above command to change all the instances of "H" to "Na+" in the file testsds.pdb at the line numbers indicated in the file 'test'. I've tried the following and various similar alternatives but nothing is working:
cat test |... (3 Replies)
Hi,
i have a flat file namely temp.txt with this data below
ID|name|contact_date
101|Kay|2013-12-26
102|let|2013-12-26
I need to modify the date data in the flat file into MM/DD/YYYY HH24:MI:SS format
let me know the code for this.
Thank you! (5 Replies)
Hi All,
I was using some commands to:
replace a column by a constant string character awk -v a=CA 'NF>1{ $3=a; print; } ' $line>$line"_1"
to copy a column and paste it in another place awk '$5=$2" "$5' $line>$line"_2"
to delete the extra columns awk '{for(i=1;i<=NF;i++)... (9 Replies)
Hello,
Here's a file of mine:
key1:431
key2:159
key3:998
I need to change these keys to something bigger - and I actually need to shift them all by a range of 3.
The output would be:
key1:434
key2:162
key3:1001
I can't find the propper sed/awk line that would alter all my... (4 Replies)
Howdy experts,
We have some ranges of number which belongs to particual group as below.
GroupNo StartRange EndRange
Group0125 935300 935399
Group2006 935400 935476
937430 937459
Group0324 935477 935549
... (6 Replies)
Good evening ...
does anyone of you know how to change major/minor numbers of disk devices ?
I had to migrate from raid1 to raid5 and this messed up my ASM cluster - I know which devices should have which IDs to match the content - but I have no idea how to change it.
Any help would be... (2 Replies)
ok, this one is definitely too hard for my shell-script-skills.
Hopefully, there is somebody who can help me with this:
I have a folder with files in it named
0.ppm
10.ppm
2.ppm
...
5.ppm
50.ppm
55.ppm
...
355.ppm
360.ppm
etc.
As you will notice, the order in which the files are... (5 Replies)