special character Æ as delimiter

[ronaldwang]

in the file I receive that I want to upload to Qlikview , Æ is used as delimiter. how can I make the file readable to qlikview? thanks

[devarasu07]

Hi,

you can try like this?

LOAD SubField(ColumnName, 'Æ') AS FieldName RESIDENT TableName;

[ronaldwang]

Hi Devarasu, currently Æ is not yet in any column and it is a supposed separator in a line of text.

[devarasu07]

Hi,

Would be able to share some mock data and expected results. Thanks

[qliksus]

Maybe you can  try with the statement like the below

LOAD @1

FROM

[File]

(txt, unicode, no labels, delimiter is  'Æ', msq);

[techvarun]

I don't think Æ is a special character and can be used as a delimiter.

May be you can replace all Æ with some other special character or you can share some sample file to check the possibilities to extract the data out of your file. 

[dinuwanbr]

Hi,

Is it possible for you to upload a sample dataset?

Rgds,

Dinu1