Skip to Content
author's profile photo Former Member
Former Member

content conversion of "property file" like files

Hello,

I have to process a text file by XI (FTP Sender Adapter)

having several sections :

Header: "property file" like format

Data : "property file" like format + CSV format

Footer : "property file" like format

And also some lines between sections that should be ignored.

For example

-


START OF FILE

START OF HEADER

Property1=aaaaaaaaaa

Property2=bbbbbbbbbb

...

PropertyN=zzzzzzzzzz

END OF HEADER

START OF DATA

PropertyX1=aaaaa,bbbb,cccccc,ddddd

PropertyX2=eeeee,ffff,gggggg,hhhhh

END OF DATA

END OF FILE

-


Do you have an idea how to parse these kind of files?

Thanks,

Bela

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Oct 18, 2006 at 04:05 PM

    Hi,

    1. Either you can read the whole file and using Adapter module you can split and form the XML

    2. You can read the whole content in one field and split it using Java/ABAP of Graphicl using UDF.

    3. Try this

    use beginSeparator = START OF HEADER

    endSeparator = END OF HEADER

    and fieldSeparator as 'nl'

    In the mapping do a substring and remove "Property1=" and get only the value

    Just an idea

    Regards

    Prakash

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Please look at this weblogs:

      /people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

      /people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

      for randor file that does not have keyfieldvalues you can use

      /people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

      Regards

      Vijaya

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.