As per the requirement, a scheduled script should be created to send saved search results to the given email address. Saved search results should be attached as CSV file.
While opening the attached CSV file, the preceding zeros are omitted in the field values.
Could you please clarify whether it is a standard feature or a limitation of the CSV file?
Can we handle it?
Solution:
Adding zeros in front of the number is a standard limitation of CSV files. We are unable to set the zeros in the same way as in the saved search that is exported directly from NetSuite.