Page Comparison

eMACH-Sigma enables you to configure a report with a specific file extension of your choice for the CSV format. You can even select a specific delimiter for the CSV format. Delimiters like comma and semicolon pave the way for the listed characters in the data sets to be distinctively separated in a proper manner. For the CSV format, the delimiters like comma and semicolon logically separate the different characters present in the data sets and the logical sequence of data will be displayed in an acute manner in accordance with the adept usage of delimiters. In eMACH-Sigma Studio, you can assign delimiters and choose a specific file extension for the CSV format with simple and effective configuration steps.

# Indicator to decide to print CSV header in CSV report output.
PRINT_CSV_HEADER = N

# Indicator to decide to print CSV footer in CSV report output.
PRINT_CSV_FOOTER = N

To configure a report in the CSV format with a particular delimiter and a specific file extension, perform the following steps in eMACH-Sigma Studio:

1. On the home page of eMACH-Sigma Studio, click Manage > Report.
   
   
   
   The Information Report screen appears. 
   
   
   
   
2. Enter a unique ID in the Report Id field, e.g. ACCOUNT_MASTER.
   
   Image Modified
   
   
   
3. Enter a unique name in the Report Name field, e.g. ACCOUNT MASTER.
   
   Image Modified
   
   
   

4. Provide the other necessary details for the report, as shown in the following screen shot.
   

   Note
   For detailed information on creating reports, refer Configuring Reports.

   Image Modified
   
   

5. In the Select Allowed Format field, click the CSV format.  
   
   Image Modified
   
   The Configure delimiter for CSV pop-up appears. 
   
   Image Modified
   
   

6. Click the Delimiter drop-down list and select the delimiter of your choice, e.g. Comma. 
   

   Note
   The available delimiters are: Comma, SemiColon, Space, Tab, Pipe and Caret.

   
   
   
   

7. Click the Text Qualifier drop-down list and select a text qualifier of your choice, e.g. Double Quotes.
   

   Note

   Text Qualifiers are used within the delimiters to indicate the beginning and the end of the contents for a particular delimited text value. If the delimited text values are indicated in double-quotes, then the text values placed within the double quotes will not get separated by the delimiter, thereby ensuring that the specified text values placed within the double quotes are considered as a single value.

   
   Image Modified
   
   

8. Click the Select File Extension drop-down list and select a file extension of your choice, e.g. csv.
   

   Note
   The available file extensions for the CSV format are: csv, tsv and txt.

   
   Image Modified
   

   
   

9. Enter '#' to view the list of functions to modify the CSV column headers in the Header Expression field and select any from the list.
   
   Image Modified
   

   Note

   The functions used in CSV headers are: Replace () - This function is used to replace a specific character with another character. For example, s:replace( value,'a','5') Where, value is a static parameter without quotes. The given character 'a' is replaced with the new character '5'. Image Modified Trim() - This function is used to remove all the leading and trailing white-space characters. For example, s:trim( value ) Where, value is a static parameter without quotes. Image Modified On the Information Report screen, click the Report Parameters tab. Image Modified If the report column headers need to be hidden when the report is generated, click the Remove Column Header in drop-down list and select the report formats which when generated must not have

   the report column headers.

   Note
   In the Sigma Application, report consumers will get the option to either turn on or turn off the report column headers only for the report formats selected from the Remove Column Header in drop-down list . By default, the report column headers are turned off in Sigma Application for the format that is configured in the Remove Column Header in drop-down list.

   
   
   
   

10. Click Save to save the report.
    
    Image Modified
    
    A confirmation message, indicating a successful save of the report, appears. 
    
    Image Modified
    
    
11. Click Ok.
    
    For detailed information on generating a CSV report with a specific file extension in eMACH-Sigma Application, refer Generating a CSV report with a specific file extension.