You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Read text file and store in db respecting the order

edited Oct 9, 2023 6:38PM in Integration 3 comments

Summary:

Hi, please I would like your help with the following:

I receive a file with this pattern:

line to remove 

line to remove 

line to remove 

<invoice>

****

****

****

</invoice>

line to remove 

line to remove 

line to remove 

<invoice>

****

****

****

****

****

****

</invoice>

line to remove 

line to remove 

line to remove 

<invoice>

****

</invoice>

--------------------------------------------------

The goal is to get a file with format similar to:

<invoices>

<invoice>

****

****

****

</invoice>

  <invoice>

****

****

****

****

****

****

</invoice>

<invoice>

****

</invoice>

</invoices>

I have thought of reading as csv and storing the file in db. and then cleaning up with pl*sql. Any simpler idea will be welcome.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!