How to use , in Inline Load

[ashishpalkar]

Hi

I am using Inline load , I want to use ',' in one value.  (Total Return Swap,Equity Index,61)

Please find below Inline load. How to use ',' in the Inline Load?

SortAsset:

Load * Inline [

AssetClass,AssetClass_SortOrder

Total Return Swap ,60

Total Return Swap,Equity Index,61

Treasury Bill ,62

Treasury Bond ,63

Treasury Note ,64

Unit ,65

Volatility Future ,66

];

Thanks in advance

[swuehl]

Try quoting:

SortAsset:

Load * Inline [

AssetClass,AssetClass_SortOrder

Total Return Swap ,60

"Total Return Swap, Equity Index",61

Treasury Bill ,62

Treasury Bond ,63

Treasury Note ,64

Unit ,65

Volatility Future ,66

];

[jaumecf23 · Accepted solution]

Hi,

Try this:

Load * Inline [

AssetClass,AssetClass_SortOrder

Total Return Swap ,60

"Total Return Swap,Equity Index",61

Treasury Bill ,62

Treasury Bond ,63

Treasury Note ,64

Unit ,65

Volatility Future ,66

];

[stigchel]

Or use a different delimiter

SortAsset:

Load * Inline [

AssetClass;AssetClass_SortOrder

Total Return Swap ;60

Total Return Swap,Equity Index;61

Treasury Bill ;62

Treasury Bond ;63

Treasury Note ;64

Unit ;65

Volatility Future ;66

] (delimiter is ';');