INLINE LOAD: How to enter a value which has a comma?

[mwallman]

Hi there,

I would like to create an INLINE LOAD table.

It will have Product Group, and Product Name fields

In my Product Name field I have some values which will be comma separated. How can I insert a value with a comma in it?

Such as

Product Name

Bread

Milk

Eggs, Meat

I don't want the comma to be confused with relating to values in the Product Group field.

[sunny_talwar]

Put the whole thing within Double Quotes

"Eggs, Meat"

[nsetty]

you can use '|' character as the alternative delimiter.

Temp:

LOAD * inline [

Customer|Product|OrderNumber|UnitSales|CustomerID

Astrida|AA|1|10|1

Astrida|AA|7|18|1

Astrida|BB|4|9|1

Astrida|CC|6|2|1

Betacab|AA|5|4|2

Betacab|BB|2|5|2

Betacab|DD

Canutility|DD|3|8

Canutility|CC

] (delimiter is '|');

[sunny_talwar]

Something like this

Table:

LOAD * INLINE [

    Product Name

    Bread

    Milk

    "Eggs, Meat"

];