Inline view with Pipeline Delimeter

[#1]

Hi

How can I make it possible to create an inline view with pipeline delimited ?

//-------------------------------------------

INLINE:

Load * Inline

[

ENAME|SAL

SCOTT|800

SMITH|900

KIND|600

];

//-------------------------------------------

But this is not working as expected..

[Anonymous]

Wondering - what prevents replacing pipe with comma?  It can be done in a few clicks

[richard_pearce6]

I don't think that it's possible. You can set the delimiter on imports such as csv files so you could load your data from there. The simplest option (unless you have commas in the data field values) would be to use search and replace to change the pipes back to commas so you can use an inline load.

[richard_pearce6]

If you have commas in the data you have to use " " around the field value

[rbecher · Accepted solution]

Hi, Consultant,

I just tried for the sake of curiosity and it worked:

INLINE:
Load * Inline
[
ENAME|SAL
SCOTT|800
SMITH|900
KIND|600
] 
(ansi, txt, delimiter is '|', embedded labels)
;

- Ralf

[#6]

Kudos Ralf . Many Thanks to you.

[#7]

I am handling that 'Unless Scenario' only Richard.. Thanks for your Understanding ..

[rbecher]

It just follows the LOAD syntax.. But, please mark it as answered then. It will help others to find it.

[rbecher]

I understand you requirement. It's much more easier to just copy / paste the data..