Network Config File to .xlsx Parser

Hi Folks -

I have a Network Configuration File (NCF) that I would like to parse in Excel 2010 to a workbook with sections of the file broken out to individual worksheets. I have written a few small VBA scripts over the past few months and have enough experience to know what CAN be done, but I do not yet know HOW to do it.

An example of a typical NCF is attached. Here is a summary description of the file format:

• An NCF can be 10000 - 75000 lines
• The NCF is compsed of sections divided by two lines: one blank and the other containing the section name in "/*------------Add/Modify Widget------------*/" format
• Each section holds multiple rows of multiple fields with variable count of each from section to section
• Rows denote specifc network elements
• Fields denote specific parameter settings for the row
• Each field is comma and space delimited with the field name and value separated by "="
• Two fields occur in most sections as index fields: "XYZID" and "CN"

Here is a summary of the workbook format I want to develop

• Each section divider signifies the creation of a new worksheet in the workbook with the name of the worksheet taken from the divider (i.e. "Widget" for "/*------------Add/Modify Widget------------*/"
• Each worksheet uses the field names in the section as Row 1 header information
• Each worksheet uses either "XYZID" or "CN" (as appropriate for the section) for Column A
• Sections not having "XYZID" or "CN" use the leftmost field name for Column A
• Remaining cells are filled with the field values for the field names in Row 1

Any advice and coding examples are greatly appreciated.

Hi Leith -

Thank you very much for the response. A workbook model of the output is attached. In putting it together I realized that there are a small handful of sections in an NCF that should be split in to two worksheets. An example in the snippet input file is the "Carrier" section, which was used for the "CCCC2000 Carriers" and "EEEE Carriers" worksheets due to a difference in field names beginning in Column G.

Again, thanks for taking a look at my post!


Best Regards,
Will

Has anyone had a chance to take a look at my project and come up with some pointers? I still have a need for this parser.

Thanks!


--Will