flat file schema parsing

hi all,

Currently i am using a flat file schema where it has Header,Record and Trailer referring to a flat file doctionary.

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…


how i can remove this space and insert the record into database ???

Can you provide the details of your flat file schema definition and the service steps used to process the file and the records?