Load single quotes in inline table

[#1]

How do i load 'AC' ,'UB' in inline table ??

When i tried i get AC and UB itself not the single quotes . Tried Chr(39)&AC&Chr(39), But even this doesnt seem to work

[sujeetsingh · Accepted solution]

Vikram ,

It means you are unable to concatenate the strings'AC' ,'UB',

See this sample.

[Sokkorn]

Hi,

This one should work

[Data]:

LOAD * Inline [

Field1,    Field2

1,    "'AC'"

2,    "'UB'"];

Or you can try with Chr()

[Data]:

Load

    Field3,

    Chr(39)&Field4&Chr(39)    As Field4;

LOAD * Inline [

Field3,    Field4

1,    AC

2,    UB];

Regards,

Sokkorn

[saumyashah90]

Hey

Try this

Load * Inline [

"'AC'","'UB'"

];

i.e " 'AC' "," 'UB' "