Igonre comma

[Former Member]

Hello,

I transfer data form FTP to Info cube in BW.

The file is CSV type.

I want to ignore from , (comma) if this appear between 2 " (inverted commas).

I try to explain - In usual I use this sign to separate between 2 fields, but in material description the , sign is part off the fields.

If the material description contain ,(comma) they appear between 2 "

I'll be happy to hear any advise.

Regards

Elad

[moorthy · Accepted solution]

Hi,

Try out with Enclosuresign etc parameter in the file content conversion.

For more on this-

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

Regards,

Moorthy

[Former Member]

Hello,

I try to use with the link and I don't found any solution.

I try to ignore from ,(comma) if they appear between 2(two) "(inverted commas ).

Regards

Elad

[Shabarish_Nair]

suppose you have your message as

"200","<b>264,940</b>",12345,"XYZ"

in this case try,

<xml>.enclosureSign = "

<xml>.enclosureConversion = NO

[Former Member]

Hello,

I try this solution without succes i explain the situtaion

The case:

222,ab23,sedee,"sfdf232,werwe""sdsddfsdf",34545,dsfg4

This is one field <b>"sfdf232,werwe""sdsddfsdf"</b>

Regards

Elad

[Former Member]

Hello Shabarish,

Thank you for your help.

It's work, I change the <xml> with word "item" like in my xml structure and now is work.

Regards

Elad

[Shabarish_Nair]

Elad glad to kow it worked

Note: Here in this forum actually we follow a norm that when we specify;

<xml>.<i>SomeParameter</i> the <xml> actually indicates the <b>node</b> (say like item in your case)