How to ignore the last recrod end separator

[Former Member]

Hi Team,

I am creating a file like below

1,100,200&2,200,300&3,300,400&

In this file

First Record is--1,100,200

Second Record is--2,200,300

Third Record is--3,300,400

I am using the field separator is ,(comma) and end separator is &.

My requirement is last record does not contain the end separator(&).

My output file should be like this

1,100,200&2,200,300&3,300,400

Regards

Swathi

[former_member303666]

Hi swathip,

Refer this doc for fine content conversion. i think this doc is little help you.

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Thanks and regards,

Kesava.

[Former Member]

Hi,

You can't remove last separator if all records are the same config.

You can do it with a script and configure it in your communication channel (Run operating system command after message processing).

Regards,

Carme

[Former Member]

Hi,

See, if this feature is useful in your case,

ignoreRecordsetName true

santosh.

[Former Member]

Hi Santosh,

Still its taking a endseparator.

[Former Member]

Swathip,

Number of records is always 3 or is it dynamic?

In case if the number of records is always 3 (for e.g. A, B and C), then mention endSeparator parameter for records A, B and don't mention endSeparator for record C.

Regards,

Geetha

[Former Member]

Hi Geetha,

the number of records are dynamic.

[former_member191435]

Hi Swathi,

You can use endseparator as '0'

Thanks,

ENivas

[Former Member]

Hi,

I need a separator for each record, but it should not read for the last record

[former_member191435]

Hi Swathi,

U can use another mapping in ur scenario.

Just take input as field with string and read whole data and create output as a field with string den do the below mapping

field1

endswith--

---

> if with out else

---

> replace string--

---

>target Field

&&

& space

field1

concat

&

first check source field is endswith & or not if it endswith & then concat & to field1 then replace && to space and map to target u will get ur scenario correctly.

Thanks,

Enivass

Edited by: enivas on Jan 12, 2012 10:57 AM