Industry Mall Online User Guide
To open the Delimited Text file using WinZip:
Double-click the .TXT file. The file opens in Notepad.
Below is an example of a file opened in Notepad with the open brace ‘{‘ delimiter. Save the extracted file by selecting File and Save As…. Remember the file location and name for importing into Microsoft Excel.
Launch Microsoft Excel and select File and Open…. Go to the directory and folder where you saved the extracted delimited price file. In the Files of type: drop-down list, select Text Files to display all .TXT files. Select File and click Open.
After opening the file, the Text Import Wizard will automatically appear to open the .TXT file in Microsoft Excel. Choose Delimited and click Next >.
Select Other and type an open brace ‘{‘ in the box. Click Finish.
The file will look like the example below with Net Price in Column L. Delete the first six lines and expand the columns to display all information. Click File and select Save As…. In the file type select Microsoft Excel.
