Feature - Equal Sign Support in Export Processor
Release Date - 1/5/18
When exporting Elliott's alphanumeric fields to CSV through the Export Processor, the leading zeroes will be dropped when the file is opened with Excel. For example, when opening the CSV in Excel, item number 0100 is displayed as 100 because the leading zero is dropped. This can be addressed by placing an equal sign before the first quote when the CSV file is created. For example, item 0100 would normally be exported as "0100." With the equal sign added, it now exports as ="0100." This forces Excel to use the values within the quotes without dropping the leading zeroes.
This feature addresses this issue. A new option has been added to the Export Processor to allow the user to choose which field should be exported with an equal sign. This feature can be enabled and disabled by pressing the right mouse button when highlighting a selected field in the list view.

A new option 'Export with "="..." is available. Once chosen, an equal sign is placed in front of the field name to indicate that it will be exported with an equal sign.
Here is an example of the exported file in Excel using the new equal sign option.
Notice that the formula shows the equal sign before the first quote. Also, notice that the leading zeroes in the customer number field are still present.
Programs Modified: NWSMMSEM
CLS
Related Articles
Feature - Toggle Equal Sign Export in User Defined CSV Export Report
Release Date: 03/14/2025 Version: 8.5 & up Added an F5 option to I/M, Report, Reorder Advice/User Def CSV, Print, User Defined CSV Export and field 7, "Item Has Attribute" to toggle the value of Export Equal Sign between Y, N, and blank. Blank is the ...
Exported Tracking Number in CSV Shows Zeroes After the 15th Digit
Release Date: 8/23/19 Version: All Q - When I go to COP -> Processing -> Print Pick/Pack Ticket & Lbls -> Shipping -> Manifest order Status Report, and I choose to export to CSV file, the CSV file has a tracking number column. When I open the CSV ...
Feature - ASCII File Filter Condition in Mass Email and Export Processor
Release Date: 1/31/19 This feature allows the user to specify an ASCII file to use as the filter condition when running Mass Email or the Export Processor application. New selection criteria has been added to the Filter tab. Users must choose if they ...
Export Processor Limitation on Processing Large Amount of Records
Release Date: 5/13/2021 Version: 8.0 & Up Q - I exported all invoice header records from our production company using Export Processor. No filters were used. As you can imagine, this took a long time. No errors were encountered while it was ...
Feature - Add User-Defined Code Table Support in IM User-Defined CSV Export
Release date: 4/12/2018 User-defined code table support has been added to the IM user-defined CSV export. The following new column types are now supported: UD: User Defined Code Description UE: User Defined Code ERG# UH: User Defined Code Hazardous ...