cancel
Showing results for 
Search instead for 
Did you mean: 

idoc to file - tab delimited file with XML field in it

agnie
Explorer
0 Kudos

I am doing simple idoc to file scenario.

The file has to be tab delimited.

My mapping is simple graphical mapping.

One of the filelds in my file has to be xml:

<properties>

<property name=u201DProperty1u201D dataType=u201Dvarchar(20)u201D value=u201DBLABLABLAu201D />

<property name=u201DProperty2u201D dataType=u201Dvarchar(20)u201D value=u201DBLABLABLAu201D />

<property name=u201DProperty3u201D dataType=u201Dvarchar(20)u201D value=u201DBLABLABLAu201D />

</properties>

The XML should not contain tabs, carriage returns or line feeds.

How would you do it?

Is there a smart way of achieving it ?

Any questions, please let me know.

Accepted Solutions (0)

Answers (2)

Answers (2)

MichalKrawczyk
Active Contributor
0 Kudos

Hi Agnieszko,

I completely understand BLABLABLA but the rest needs some clarifications

do you want to have tab delimited file with XML content inside?

can you use/have that XML content in CDATA section ?

(as that would be the easiest way to store XML data into the tab delimited file)

if not you may need use other kind of mapping (abap,java) in order to

do the mapping to the tab delimited file inside the mapping and not in the file CC

Regards,

Michal Krawczyk

Shabarish_Nair
Active Contributor
0 Kudos

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

it talks about reading a TAB delimited file. You can reference the same to help you with creating a TAB limited file (check the parameter .fieldSeparator that is the key)

you dont have to include any TABs in the mapping.

Some other help for the receiver file adapter is;

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

/people/shabarish.vijayakumar/blog/2007/08/03/file-adapter-receiver--are-we-really-sure-about-the-concepts

agnie
Explorer
0 Kudos

Thanks for this, but my question was not about creating tab delimited file but about creating an xml formatted field within a tab delimited file in a smart way.