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 ...
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 Does Not Find Record Due to Space in Item Number
Release: 7/2/2021 Version: 7.5 & Up Q - I attempted to run the Exporter on the Sales History TRX looking for sales equal to 9835-GS KIT. It pulled back 0 sales. See sample screen below: Knowing this to be not valid, I then ran the Exporter looking ...
Explanation of ATP LP Type - Negative Sign (-) vs (*) Symbols
Release Date: 5/17/17 Q - For the ATP (Available to Promise) processing screen, can you advise what the “ * “ (asterisk) symbol means next to the 792*? Also, why do some LPs have the ” - “ (negative sign) and some are blank. See sample screen below: ...
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 ...