Forum Stats

  • 3,734,273 Users
  • 2,246,935 Discussions
  • 7,857,216 Comments

Discussions

I need to import a fixed columns file in oracle apex 20.1

User_JXCDF
User_JXCDF Member Posts: 1 Green Ribbon

I need to import a fixed columns file in oracle apex 20.1


I have a file in txt format, where the data is in fixed width columns, how do I import this data in apex 20.1 for an end user. Thank for you help.

Answers

  • fac586
    fac586 Senior Technical Architect Member Posts: 19,676 Black Diamond

    Please upgrade upper forum profile with a recognisable username instead of "User_JXCDF".

    I need to import a fixed columns file in oracle apex 20.1

    I have a file in txt format, where the data is in fixed width columns, how do I import this data in apex 20.1 for an end user.

    Use the apex_data_parser API, treating the input file as being a CSV file containing a single column, with an outer query that slices this column using substr according to the fixed column format.

    Install and review the Sample Data Loading packaged application for examples.

Sign In or Register to comment.