ABAP CSV TOOLS

This repository contains a lightweight but flexible framework to parse csv files in ABAP.

Motivation

ABAP provides some different function modules or classes to import csv files, but no one supports all the following features:

Support for different field separators
Support for different field delimiters
Support for escaped delimiters used in field values (e.g. "This ""is a quoted"" value")
Support for line breaks in delimited field values (e.g. "This value \n contains a new line")
Identify the column by header title instead of position
Import column value without a priori knowledge of the datatype
Transform or convert values during import
Support for events

Examples

See report zsrbcsvtoolsexample for more examples.

Convert a csv file to a `STRING_TABLE`

DATA(csv) = |date,gross_value,currency code\n10.03.2023,"27,33",eur\n11.02.2012,"33,33",eur\n11.03.2023,"3,33",usd|.

DATA(csv_to_table_converter) = NEW zcl_srb_csv_to_stringtabtab( ).
csv_to_table_converter->set_parser( NEW zcl_srb_csv_parser( ) ).
DATA(csv_table_data) = csv_to_table_converter->parse( csv ).

cl_demo_output=>display_data( csv_table_data ).

Using different separators an delimiters

Can be done if a new confituration class is created which implements interface zif_srb_csv_parser_config:

CLASS csv_config DEFINITION.
  PUBLIC SECTION.
    INTERFACES: zif_srb_csv_parser_config.
ENDCLASS.

CLASS csv_config IMPLEMENTATION.
  METHOD zif_srb_csv_parser_config~is_char_field_delimiter.
    is_delimiter = xsdbool( char = |'| ).
  ENDMETHOD.

  METHOD zif_srb_csv_parser_config~is_char_field_separator.
    is_separator = xsdbool( char = |;| ).
  ENDMETHOD.

  METHOD zif_srb_csv_parser_config~is_char_line_separator.
    is_separator = xsdbool( char = |\r| OR char = |\n| ).
  ENDMETHOD.
ENDCLASS.

Pass the configuration object to the parser object:

csv_to_table_converter->set_parser( NEW zcl_srb_csv_parser( configuration = NEW csv_config( ) ) ).

Convert a csv file to json

Why? Since the class /ui2/cl_json provides powerful json deserialization the idea was to transform csv to json in order to use the existing code.

DATA(csv) = |date,gross_value,currency code\n10.03.2023,"27,33",eur\n11.02.2012,"33,33",eur\n11.03.2023,"3,33",usd|.

csv_to_json_converter = NEW zcl_srb_csv_to_json( ).
csv_to_json_converter->set_parser( NEW zcl_srb_csv_parser( ) ).
json = csv_to_json_converter->get_json( csv ).

cl_demo_output=>display_json( json ).

Authors

Andreas Ferdinand Kasper - initial code base - SRB Consulting Team GmbH

License

This project is licensed under the MIT License - see the LICENSE file for details.

SRBConsultingTeam/ABAP_CSV_TOOLS