Feature - Equal Sign Support in Export Processor

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 - Support 12 Months History in Export Processor

      Release Date - 7/13/17 Note: This feature is only available in version 8.2 and above. The Export Processer now supports the 12 Month History Summary file for the following tables and values: Customers: Total sales for the customer by period Total ...

    • Using the Export Processor to Export Data

      Q: It has been a while since we used the Export Processor to Export Data from Elliott. I remember how to select the category and choose the search data, but I can't remember how to select all the fields that need to be processed for export. Can you ...

    • How to Find a Record that Does Not Have a Certain Attribute in Export Processor

      Release Date: 03/21/2024 Version: 8.0 & Up Q - Just so we're sure of ourselves over here, there is still no way to use Export Processor to find records where an attribute is NOT attached to the record, correct? We're needing to filter this way often ...

    • 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: ...

    • 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 ...