Skip to Content
avatar image
Former Member

content conversion parameters necessary for fixed length file

Hi,

I new to xi.The scenario is that i have to handle a fixed length file where the records repeat after every 80 characters.Can anyone help me as to how thw identify the start of every record based on length

thanks and regards ,

srinadh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 29, 2007 at 03:51 AM

    hey

    have a look at the following

    /people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

    thanx

    ahmad

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Hey i have a small doubt.My input is like this

      99443 123213 232234 12312

      127544 23423

      Here i have four recorsetnames namely HEADER1,HEADER2,HEADER3,HEADER4,HEADER5,HEADER6so i specified the following parameters

      HEADER1.fieldFixedLengths=1,3,1

      HEADER1.fieldNames=value1,value2,value3

      HEADER1.endseperator=" "

      HEADER2.fieldFixedLengths=1,3,2

      HEADER2.fieldNames=value1,value2,value3

      HEADER2.endseperator=" "

      MY OUPUT XML STRUCTURE SHOULD BE like this

      <header1>

      <value1>9<\value1>

      <value2>944<\value2>

      <value3>3<\value3>

      <\header1>

      <header2>

      <value1>1<\value1>

      <value2>232<\value2>

      <value3>13<\value3>

      <\header2>

      Is the content conversion parameters i specified enough for that

  • avatar image
    Former Member
    Jun 29, 2007 at 05:09 AM

    Hi,

    Hey i have a small doubt.My input is like this

    99443 123213 232234 12312 127544 23423

    Here i have four recorsetnames namely HEADER1,HEADER2,HEADER3,HEADER4,HEADER5,HEADER6 all the recordsets are of same size but the lengths of the fields in it vary so i specified the following parameters

    HEADER1.fieldFixedLengths=1,3,1

    HEADER1.fieldNames=value1,value2,value3

    HEADER1.endseperator=" "

    HEADER2.fieldFixedLengths=1,3,2

    HEADER2.fieldNames=value1,value2,value3

    HEADER2.endseperator=" "

    MY OUPUT XML STRUCTURE SHOULD BE like this

    <header1>

    <value1>9<\value1>

    <value2>944<\value2>

    <value3>3<\value3>

    <\header1>

    <header2>

    <value1>1<\value1>

    <value2>232<\value2>

    <value3>13<\value3>

    <\header2>

    .......

    Is the content conversion parameters i specified enough for that. I wanted to know how would it know the begin of the next recordset(ie the seperation between the two recordsets) .Please help me its vey urgent

    Thanks in advance

    Sriandh

    Add comment
    10|10000 characters needed characters exceeded