Shell Programming and Scripting

Hi ennstate(Nagarajan G)

Thanks a lot for your revise. I have revised my(your's) coding without END statment and it's work...!! Great..!

But, I don't know why the coding skipped the first line from the calculations..!!
May be, because, it does have only one digit before the decimal point..?
I don't know?

Do you have any Idea?

The Output file after removing the END statement, but, without the calculation of the first line...!!, look like this:
So, from first looking for the first line, the script just remove the sign "-" from the Latitude number, without any calculation. And, he didn't remove the sign "-" from the Longitude number, and without any calculation..!!

Any Idea? Why?

However, I'll try again for new data file...!!

I appreciate your help ennstate very much.

Amm

I assumed that those fields are like NUMBER-NUMBER.NUMBER,but i think the first line of the input file had an
25- 9.21 "space" between them , so it was not included in that calculation.

If you expect that the input may contain space in those fields then,we may hav to change the logic

Thanks
Nagarajan G

Hi again

I have discovered the problem some how exactly.

As I mentioned Above, the representation of the digit number in Minutes is the key word for solving this problem. For example, the digit number for the first line is 9.21 NOT 09.21, and the same for the last line, is 8.88 NOT 08.88.
Thats why the coding dosen't want to go throw the calculation for those lines.

Any Idea how to solve this small problem?

Otherwise, any Idea on how to search for it inside the file(Inputfile in this case), and fix it manually by adding ZERO "0"..?

Last output file:
Another problem, it seems that the calculation won't go for all the digit numbers. Mean that, he do skip some arbitrary numbers like this one, 24.5112 39-56.35 , he calculate the first one but, he didn't for the second...?? strange...!!

Any Idea and help are very much appreciate it..

Thanks
Amm

Hi ennstate

Thanks again for your nice comments.

I have checked the input file, and it does include space on it.

So, I think we need to change the logic as you mentioned before.

Plus, I need the output file, to be Tabbed spaced between each columns inside the file.
To make it easy for other applications. Is it possible..!!

Any ways thank you again.

Amm

Firstly before we proceed to fix this,we need to agree on few points.

1) The total number of fields that the input field is going to contain.
2)How are those fields are separated.
3)The position of the fields of interest
4)Possible patterns that those fields can have

Only then we can arrive at a good solution.

The script has missed those two lines
960109 914 4.54 25 9.21 40-50.34 14.83 2.81 12 335116.5 0.26 6.8 81.7 D1 -No hyphen
951107 6 3 23.22 24.5112 39-56.35 5.68 1.85 8 222 7.6 0.11 1.5 1.4 - they are not 4 th & 5 th fields here
951108 554 20.09 25 8.88 41-15.85 10.00 2.94 7 339153.6 0.14 5.2211.8 D1 - No Hyphen

Thanks
Nagarajan G

Hi Ennstate

Thank you for your reply again.

OK. May I can answer your questions by posting all the input and output file below. But, I have just discovered that and noticed that, there is big different between posting the file as QUOTE and PHP in this html forms.
The QUOTE forms gave arbitrary spacing for the file, with no specific format. Not like the PHP forms, gave the exact format of the file inside my machine, with spacing between each column.

This is the Input file using QUOTE forms:
The same Input file using PHP, which gave the exact format with spacing, as it's look in my machine:
And this the output file format using PHP, and you can see, with some how unorganised format after running the AWK code script:
The interesting field for me, as I explained before is, 1st filed, 4th ~14th.

So, that's all, and I hope this can answer your questions.

looking forward for your help

Thanks
Amm