How to copy the selected parameters from Delta V explorer to Excel?

  • There isn't an easy way to just right click and copy selected data into another program. There are ways to get the data you need via a fhx file, but this is cumbersome to do manually, and takes some skill to use a script to parse out the pertinent data. Bulk edit is another tool to extract from DeltaV, but it takes know how and usually some trial and error to get exactly what you are after.
  • I use Notepad++ v7.9.5 (latest) that may be obtained by free download at notepad-plus-plus.org/download/. Obtain the .fhx file that you want the list of parameters from and open it in Notepad++. Search for the parameters using "Search" located at the top Menu Bar, then select "Find" from the drop down menu. For the "Find what : " box type in "ATTRIBUTE_INSTANCE", then select the "Find All in Current Document" BUTTON/BOX. The list should show up in the lower horizontal window "Search results - (nnn hits)" that the search routine provides when it completes its execution. Move your cursor to the first Parameter that should appear near or in the first row similar to this format:
    "Line 3795: ATTRIBUTE_INSTANCE NAME="PHASE_TYPE"" and select all those parameters listed in that window by holding the left mouse button and dragging down to last one in the list. Right Click the mouse and select "Copy". Next, paste in a new blank spreadsheet in Excel. Once pasted go to "Find & Select" and choose "Replace". In the Find and Replace window and for the "Find what :" box type *="  "and leave the "Replace with : " box empty or blank. Select the "Replace All" button and then repeat the replacement for the close quotation mark remaining at the end by typing "Find what : " box and leave the "Replace with: " box empty or blank. Result is your parameter list.

  • You can use SysExporter from Nirsoft as well, this is a windows executable and copies data from most (DeltaV) windows to a text file or directly into Excel.
  • In reply to Pieter Degier:

    Yes Peter this works really well.

    I use it extensively on DeltaV Development systems but I'd be wary of installing onto a DeltaV Production system. I would be surprised if Emerson would support it's installation on a Live Production system professional plus or professional workstation.