I am trying to create a spread sheet to allow easy data entry into another piece of software.
Firstly a DSI file is exported from the software which can be opened in Excel.
The first block of data needed appears in the first column between rows which are "!terminals" and "!".
As the "!" entry is not unique I may have to use the next row of "!Harness extra node components".
Is there a way to specify the data between the two mentioned above as a table for lookup purposes?
I need the data hi-lighted in green to be formatted into a table as per TAB 2 (connector table).
Only the first two parts of the row are required, the connector reference CONN1, SP001 Etc and the cavity after the : 1, 2,3,4,L,R,X Etc
They should appear in the table in order if possible (see TAB 2 connector table).
thanks for looking.
Bookmarks