How to suppress Blank records

[former_member210730]

Hi All,

I am having a tab delimeted .txt file which contains blank records which need to be supressed otherwise i get empty XML tags in the output as shown below.

- <Header>

<PERNR />

<BEGDA />

<ENDDA />

<SCHKZ />

</Header>

Actually i am getting a tab in PERNR field. I tried the createif function but its not working .Can anyone help me out in this

[Former Member]

Hi,

The following way is one way if you are using sender file with content conversion.

NameA.fieldContentFormatting

&#9679; Specify trim to remove all the leading and subsequent blanks for a value found. This is the default.

&#9679; Specify nothing to ensure that the value remains unaltered.

The second way is..

if target structure is 0..unbound then

source -- exists-- createIf -- target node

or write UDF to handle input string is null then return

ResultList.SUPPRESS in you UDF.before that the target parent node/node should be having occurrences 0..unbound/0..1

please clarify

Regards

Chilla..

[prateek]

Hi Vinay,

This could help u out

/people/stefan.grube/blog/2006/01/09/the-use-of-suppress-in-the-xi-30-graphical-mapping-tool

Regards,

Prateek

[Former Member]

Vinay,

dont use fieldContentFormatting in sender file adapter you wont reciver space in PERNR.

otherthing use "IF" boolean function in our mapping if blank then supress and pass it to target .

Regards

sreeram.g.reddy