Currently i am using a flat file schema where it has Header,Record and Trailer referring to a flat file doctionary.
90;534f;df;b; —> trailer
i am using record delimiter as ‘new line’ and i am supposed to insert only the record section into the database… i am using trim function for the record content to remove spaces while storing in database… but its not working… i can see in the database its still inserting the record with a new line…
how i can remove this space and insert the record into database ???