I have an csv file which contends value GPS time for each record and x, y coordinates.. The purpose is to identify which vps does not match with the law parameters in the relation time and offset.
In the graphic attached you can see example of 3 vps which are showed in red color and falls in the area not allowed. All records marked as blue are ok.
Then the thing is to sort the records by GPS time .. ( I did this part in my script ). calculate the time from GPS time as HHMMSS. ( done ).. now we need to duplicate say 10 time each record and write in front the next ones ( example analysis_25.csv ).
Here is the time to calculate the offset (column 18) and time (column 19) in the file analysis_25.csv..
Using the Law parameters we need to compute the Allowed_SlipTime ( column 19 ) and with this value we can define witch records are bad ( bad_records_25.csv) ...
In the graphic analysis_25.png we can see how the law works by time and offset
Values for law are:
Here my script till now.
I am performing some operation like:
SQL Statement below:
UPDATE table2 SET column1_table2 = ( SELECT column1_table1
FROM table1 WHERE column2_table1 = column2_table2 LIMIT 1)
LIMIT 2;
So what I'm trying to do is to find a corresponding value and then I'm adding it into table2. Now how... (2 Replies)
I have a very big file of 5gb size and there are about 50 million records in there. I have to delete the records based on recrord number that I know fromoutside with out opening the file. The record numbers are very random like 5000678, 7890005 etc.
Can somebody let me know how i can... (5 Replies)
Function: int fcntl(int fd, int cmd, struct flock * lock)
Data Type: struct flock
This structure is used with the fcntl function to describe a file lock. It has these members:
off_t l_start
This specifies the offset of the start of the region to which the lock applies, and... (1 Reply)
Hello. I just found out about awk, and it appears that this could handle the problem I'm having right now.
I first stumbled on the thread How to extract first and last line of different record from a file, and that problem is almost similar to mine.
In my case, an ASCII file will contain the... (0 Replies)
Hi,
I need to come up with a site that will display all the records in the database, but one at a time.
Not sure how to go about it.
Please pour in your suggestions.
Thanks
---------- Post updated at 04:38 AM ---------- Previous update was at 12:52 AM ----------
Can... (3 Replies)
How do i find the record which has been edit the last 10 minutes?
from a.txt which has last field is epoch time updated.
10/17/2012 1:47 PM||||||In Use|chicken||1350005487
10/17/2012 2:53 PM||||||Available|chicken||13500000
10/17/2012 3:20 PM||||||In Use|cat||1351000000
10/17/2012 3:22... (2 Replies)
Hi,
I am trying to get the position of a repeated string in a line using
grep -b -o "pattern"
In my server I am using GNU grep version 2.14 and the code is working fine. However when I am deploying the same code in a different server which is using GNU grep version 2.5.1 the code is not... (3 Replies)
Dear all,
I want to offset the file numbers. can you please make some awk code or linux code for the same.
Example:
input file names
ANI_WFMASS_PIST00001.gif
ANI_WFMASS_PIST00002.gif
.
.
.
ANI_WFMASS_PIST0000n.gif
offset --> 30
ANI_WFMASS_PIST00031.gif
ANI_WFMASS_PIST00032.gif... (14 Replies)
Hi Team,
Is there a way to grep time taken to save records.
Its like there is one webpage where when I click save button taking so much time to save result.
Therefore, I want to grep that time taken to save that record from file.log
Thanks in advance. (1 Reply)
Input File:
E 3359799 3360148 350 X
D 3471287 3471607 321 X
E 3359799 3360740 942 X
E 4359790 4360039 250 X
.
.
.
Desired Output File:
E 3359799 3359998 200 X
E 3359999 3360148 150 X
D 3471287 3471486 200 X
D 3471487 3471607 121 X
E 3359799 3359998 200 X
E 3359999 3360198 200 X... (1 Reply)