Help !! Need macro code for get row value?

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)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

The file you attached was blank

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

Probably with something like this:

Please Login or Register  to view this content.