Loading values with Comma through flatfiles

[Former Member]

Hi,

I am loading data through flat files

I have characterstics like Industry ,Company . Module & Keyfigure Sales

Company___ Industry___Module ______Sales

XYZ Banking CS,CB,CD 10

I have a data with commas in the characterstic Module. If I use the Data Separator as , then as soon as it sees the comma in the data the for example as soon as it sees comma after CS the Cb value will got to the next field & if I am using Data Separator as ;

In my CSV file then its loading the entire data in to one column Company

Like this

Company

XYZ;Banking;CS,CB,CD;10

How can the comma data be laoded in to the BW

Thanks

SVR

[Former Member]

Company___ Industry____ Module ______Sales

XYZ ______ Banking ___CS,CB,CD _____ 10

[Former Member]

Its Solved