FileContentConversion

[Former Member]

Hi All,

I am working on FlatFile Sender.The FlatFile format is like this

"aaa","bbb","ccc"

"xxx","hhh","ooo"

Each and every field value is in double quotes. Is it possible to pick this type of file by FileContentConversion?

Please guide me,how can i pick these types of files using FCC.

Thanks,

SreeLatha.

[former_member191435]

Hi Srilatha,

There is 2 ways u can do the above one.

1. if you want to read file as it is with " u have to use below 2 parameters in Sender FCC

Name Value

i). NameA.enclosureSign blank

II). NameA.enclosureSignEscape "

if u want to read fields without " use

i) NameA.enclosureSign "

for more understanding follow below link :

http://help.sap.com/saphelp_nw04/helpdata/en/bc/bb79d6061007419a081e58cbeaaf28/frameset.htm

2. Otherwise u can remove " in the message mapping using string operations . i.e. replacestring

Replacestring with 3 inputs as.

1. field1

2. "

3. constant without space.

Please let me know if you want anything.

Thanks,

Enivass

[former_member472138]

Just give a search in SDN, You can get many threads.

http://www.riyaz.net/blog/xipi-file-content-conversion-for-simple-structure/technology/sap/75/

Regards

Pothana

[former_member688508]

In Sender communication channal, fieldSeparator property use "," and try it.

In message mapping check, value starting with " and end with " should remove it.

Regards,

Kumar