hi all,
Currently i am using a flat file schema where it has Header,Record and Trailer referring to a flat file doctionary.
eg:
10;a,b,c -->Header
30;45;56;345; —>record
30;56f;dfg;5tf;gfg —>record
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…
eg:
30;fgd;5434;gfb;54;4534
how i can remove this space and insert the record into database ???