UNIX for Dummies Questions & Answers

The script I am looking for is :

If In first column repeats
then the column value + .1, else column.

I have attached two files :
Orginal_las.txt :is the original file unsorted and with some repeating values in column 1.
result_las.txt : is the the result I am looking for, sorted and no repeating values in column 1.

regards

Code:

for file in *.las
do
  { # reading from file
    # header
    while read line
    do
      echo "$line"
      case $line in "~Ascii"*) break;; esac
    done
    # sort the rest and add number suffix for duplicates
    sort -k1,1n |
    awk '{if ($1==p1) {sub("  ","."++c)} else {c=0; p1=$1} print}'
  } < "$file" > "$file.new"
done

Thanks Don and MadeInGermany

Know it is working .

regards

I'm glad that what MadeInGermany suggested is working for you. But, of course, if the 1st line in the sample input you provided in post #9 in this thread:

Code:

11200.45 abc 400 1 name2
11204     abc 230 1 name
11204     abb 350 2 name
11500     abc 400 1 name2
11632     .... ..... .  .........
11632   .....
11900

had another entry with the same decimal value (or if any two lines in your input contained the same value including a decimal point), it just won't work. First the code would try to replace the first two spaces in the on the 2nd matching line with .1 creating (if there were to spaces in that line) 11200.45.1 (which is not a valid decimal number). And, second, if the input can contain decimal values in the 1st column, there is nothing in MadeInGermany's code to detect duplicates created as a result of adding the .1 to the ends of a duplicated line that didn't contain a decimal point.