Writing multiple files from one file after comparing each line

jlrod912 · 06-25-2012, 04:25 PM

I have one text input file that contains times (HHMMSS) on each line. Each line is compared with the next line and if a condition occurs (time between each consecutive line is less then 90 seconds) the lines are written to a file. The input file may contain several lines that are duplicate lines or consecutive lines that are more than 90 seconds apart. I want to read the input file and write as many separate files that contain consecutive times that meet the time test of 90 seconds or less. I already have the formula to compare the times. Does anyone have any suggestions on how to write this in a bash script? Thanks in advance for your help.

Example of 1 input file that should generate 3 output files follows:
FileIn.txt
120749
120749
120749
120914
121040
121205
121331
121456
121621
121747
121912
122038
122203
122328
122452
122617
122743
122743
122743
122908
123034
123512
123800
124310
124320
124330

There should be three separate output files as follows:
FileOut1.txt
120914
121040
121205
121331
121456
121621
121747
121912
122038
122203
122328
122452
122617

FileOut2.txt
122908
123034

FileOut3.txt
124310
124320
124330

rosehosting.com · 06-25-2012, 06:01 PM

If you want to use plain bash, go with arrays.

First create an array from your file

Code:

while read line
do
    array+=("$line")
done < FileIn.txt

Loop through the array, and use your formula

Code:

for (( i = 0 ; i < $((${#array[@]}-1)) ; i++ ))
do
    #Your formula

done

For example to compare if time between each consecutive line is less then 90 seconds

Code:

    if [ $((${array[$i]}+90)) -lt ${array[$(($i + 1))]} ] ;then 
        echo "${array[i]}"
    fi

jlrod912 · 06-26-2012, 03:05 PM

Thank you, that code works great. How do I implement the part where I make the 3 separate output files
from the one input file after I have all the times in one array? I am having problems putting all the grouped times that meet the less than 90 seconds requirement in separate files. Thanks in advance again for your help.

Quote:

Originally Posted by rosehosting.com

If you want to use plain bash, go with arrays.

First create an array from your file

Code:

while read line
do
    array+=("$line")
done < FileIn.txt

Loop through the array, and use your formula

Code:

for (( i = 0 ; i < $((${#array[@]}-1)) ; i++ ))
do
    #Your formula

done

For example to compare if time between each consecutive line is less then 90 seconds

Code:

    if [ $((${array[$i]}+90)) -lt ${array[$(($i + 1))]} ] ;then 
        echo "${array[i]}"
    fi