webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

flat file schema parsing

  • 1.  flat file schema parsing

    Posted Fri August 21, 2009 06:09 AM

    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 ???


    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: flat file schema parsing

    Posted Fri August 21, 2009 03:24 PM

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


    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods


Related Content