AnsweredAssumed Answered

Need python for converting data format

Question asked by deepakts08 on Mar 26, 2014
Latest reply on Mar 26, 2014 by deepakts08
[HTML]
<pre>
Hi All
The below is the exisitng data in a file running over 24768 lines

there are dublicate names linke (abc) , width and FLof which stands for offset


        file A
------------------
###########################################################################
# F      Name    Gro  Width   FLof Class
###########################################################################
1cbb     abc      -    6       2  INDIRECT
1cbc     xyz      -    3       0  INDIRECT
1cbd     abc      -    4       0  INDIRECT
1cf3     bcd      -    3       5  INDIRECT
1cf4     pqr      -    3       0  INDIRECT
1cf5     bcd      -    8       0  INDIRECT
---------
---------- so on


I want a script to convert the file data to as folowing data :

      file B
-----------------
###########################################################################
# F      Name           Gro  Width   FLof Class
###########################################################################
1cbb     abc_7_2         -    6       2  INDIRECT
1cbc     xyz             -    3       0  INDIRECT
1cbd     abc_11_8        -    4       0  INDIRECT
1cf3     bcd_7_5         -    3       5  INDIRECT
1cf4     pqr             -    3       0  INDIRECT
1cf5     bcd_15_8        -    8       0  INDIRECT


Explaination for conversion is here
first row abc has width as 6 and FLof as 2 in file A, so it occupies position  2,3,4,5,6,7 accounting to 6 position so represented as abc_7_2 in file B
Now row three of file A has duplicate of abc so now the new offset will be previous offset plus one ie. position will start from 8 and it goes as follows 8,9,10,11 so represented as abc_11_8
this wil create unique and informative names
the same goes with other rows

Can any one get me python script for this
I tried with dictionary but i field to nail it down

please help
thanks in Advance
Deepak
</pre>
[/HTML]

Outcomes