Field Suppresion in output text file.

[former_member238007]

Hi.

I need to suppress the field under one header, the header has only one field and in the output file i dont want this field where i am using this field for dynamic naming for the output file.

required any content conversion parameters which supports for this requirement..

regards,

Kishore

[Former Member]

Hi Kishore

You can refer to below links for ur problem.

[/people/shabarish.vijayakumar/blog/2008/01/09/rosettanet-rnif-xi--breaking-the-code|/people/shabarish.vijayakumar/blog/2008/01/09/rosettanet-rnif-xi--breaking-the-code][/people/shabarish.vijayakumar/blog/2007/07/26/troubleshooting-the-file-adapter-last-updated-on-02-july10|/people/shabarish.vijayakumar/blog/2007/07/26/troubleshooting-the-file-adapter-last-updated-on-02-july10][/people/shabarish.vijayakumar/blog/2007/08/03/file-adapter-receiver--are-we-really-sure-about-the-concepts|/people/shabarish.vijayakumar/blog/2007/08/03/file-adapter-receiver--are-we-really-sure-about-the-concepts][https://www.s[http://sapient.xi.googlepages.com/xi-excellentintegration|http://sapient.xi.googlepages.com/xi-excellentintegration]/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter|https://www.s/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter]

- Sarang

[rodrigoalejandro_pertierr]

Hi, Thanks for your help.

i 've seen Sravya's blogs and that my first solution using FCC and variable substitution and doesnt work.

as i can see using xml.endSeparator or xml.absoluteRowWidth a blank line is created no matter if there is more data or no to conver from xml.

i Mean if my structure is:

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:mt_PricingMasterFile xmlns:ns0="http://spsa.com/POS/MasterPricing">

- <Lines>

<BarradelProducto>7750243005791</BarradelProducto>

<DescripcionDelTicketyBalanza>PRIMOR ACEITE CLASIC</DescripcionDelTicketyBalanza>

<Departamento>0002</Departamento>

</Lines>

</ns0:mt_PricingMasterFile>

the result file is all data in one line and a blank line.

if i have the next structure

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:mt_PricingMasterFile xmlns:ns0="http://spsa.com/POS/MasterPricing">

- <Lines>

<BarradelProducto>7750243005791</BarradelProducto>

<DescripcionDelTicketyBalanza>PRIMOR ACEITE CLASIC</DescripcionDelTicketyBalanza>

<Departamento>0002</Departamento>

</Lines>

- <Lines>

<BarradelProducto>7750243005791</BarradelProducto>

<DescripcionDelTicketyBalanza>PRIMOR ACEITE CLASIC</DescripcionDelTicketyBalanza>

<Departamento>0002</Departamento>

</Lines>

</ns0:mt_PricingMasterFile>

the result is one two lines and a blank line.

So as i can see using xml.endSeparator or xml.absoluteRowWidth a blank line is created no matter if there is more data or no to conver from xml. ussing the FCC defined in my previous post

is there anyway to say the system: create a new line only if the next line is not EOF

Thanks

RP

[Former Member]

Hi

Map your dynamic configuration to header segment instead of your filed under header. Anyhow this filed is not reauired at your target side I guess and make this filed occurence as 0.to 1. you are not mapping this filed in the mapping so it wont genarate at target side.

Regards

Ramesh Varanganti

[former_member238007]

Hi..

is there any way to remove the spaces in the output file

else can we replace the spaces with null.

regards

Kishore

[Former Member]

You can use replace string standard text function, replace space with empty in the mapping.

it will work

Reagrds

Ramesh Varanganti

[Former Member]

Hi Kishore,

I assume you are having a blank line for the structure you are using for File name. If yes then try this sravyas blog:

/people/sravya.talanki2/blog/2005/08/11/solution-to-the-problem-encountered-using-variable-substitution-with-xi-sp12

If it didnot work then try to put this parameter for that structure:

Try with '0x08' this is for backspace even though it prints lets it delete it and see.

See this for more info for hex:

http://web.cs.mun.ca/~michael/c/ascii-table.html

Regards,

---Satish

[Former Member]

Hi ,

I am not clear about your requirment and if am right , if you dont need a particular field in the o/p you can simply disable that field right.

And for the Dynamic file you can use the UDF .

Regards,

B.Jude