How to import dat file with column and Quote delimiter

[Abhinav_1911]

Hi, 

I'm trying to import a dat file with DC4 as column delimiter and þ as a Quote delimiter. can someone please tell how to load this type of dat file in Alteryx?

[binuacs]

@Abhinav_1911 Can you provide a sample file 

[Abhinav_1911]

Hi @binuacs

I'm unable to attach file here. It doesn't support data file. I have copied the file content below. The row column is DC4 and Quotes delimiter is þ.

þTestþþColumn1þþColumn2þ
þTest123þþabcdþþiIgklþ
þTest345þEFGHþþMnopþ

[binuacs]

@Abhinav_1911 put the delimiter as \0 , then it will import all the records to one line, then try to split with the text to column tool