Hi All
I have some information In A column like as below(excel attached) , I want to extract the data of redcolor highlight information and blue color highlight information. result need to column B & C. like as 500 row data available (attached excel sheet may be empty due to security resin) please copy this information to excel.
segment:xy (6781.200 -17318.660) xy (6781.200 -17113.730) width (35.000)
segment:xy (6781.200 -17113.730) xy (566.060 -10898.590) width (35.000)
segment:xy (566.060 -10898.590) xy (566.060 -4750.000) width (35.000)
segment:xy (566.060 -4750.000) xy (566.060 -3331.100) width (13.000)
segment:xy (566.060 -3331.100) xy (235.300 -3000.340) width (13.000)
segment:xy (235.300 -3000.340) xy (235.300 -1751.620) width (13.000)
segment:xy (235.300 -1751.620) xy (235.300 -1740.850) width (8.000)
segment:xy (235.300 -1740.850) xy (222.140 -1727.690) width (8.000)
segment:xy (222.140 -1727.690) xy (222.140 -1673.720) width (8.000)
segment:xy (270.120 -1625.740) xy (270.120 -1596.881) width (8.000)
segment:xy (270.120 -1596.881) xy (293.586 -1573.415) width (8.000)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Item 2 < CONNECT LINE >
class ETCH
subclass CMI_MEMB_1_2
Part of net: TC__2918
Length: 17505.23159
Net path length: 38199.67759
Total manhattan length: 20674.446 UM
Percent manhattan: 184.77%
Connections:
VIA at xy (244.655 -1600.899)
segment:xy (5797.530 -16765.860) xy (5797.530 -16229.055) width (35.000)
segment:xy (5797.530 -16229.055) xy (496.060 -10927.585) width (35.000)
segment:xy (496.060 -10927.585) xy (496.060 -4750.000) width (35.000)
segment:xy (496.060 -4750.000) xy (496.060 -3303.520) width (13.000)
segment:xy (496.060 -3303.520) xy (209.300 -3016.760) width (13.000)
segment:xy (209.300 -3016.760) xy (209.300 -1751.620) width (13.000)
segment:xy (209.300 -1751.620) xy (209.300 -1740.850) width (8.000)
segment:xy (209.300 -1740.850) xy (196.136 -1727.686) width (8.000)
segment:xy (196.136 -1727.686) xy (196.136 -1649.418) width (8.000)
segment:xy (196.136 -1649.418) xy (244.655 -1600.899) width (8.000)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Bookmarks