CSV File unterschiedliche Trennzeichen

[Massi1]

Hallo zusammen, 

ich habe eine CSV Datei die unterschiedliche Trennzeichen in der ersten Zeile hat. Die erste Zeile sind die Spalten überschriften. Dort ist das Trennzeichen mit einem Leerzeichen getrennt. In den Zeilen darunter sind " als Trennzeichen. 

Wie kann ich das in eine einhaltliche Tabelle erhalten? 

[ImadZidan]

Hello @Massi1 ,

My German is very rusty sorry.

Can you provide a sample file. I think you can use multiple separators. But need to be certain.

[Massi1]

Hey, 

I have a CSV file with different delimiters. In the First row I have spaces and after the first row I have the delimter " 

So how can I delimiter the in Alteryx 

[ImadZidan]

Hello @Massi1 ,

Something like this. If not provide a sample files with the first two records at least.

Hope it helps

[Massi1]

can you give me the worklfow. because your message is empty

[ImadZidan]

@Massi1 ,

Oh sorry. 

[Massi1]

Its not working. 

The Header have spaces and the first row have " as delimiter

[ImadZidan · Accepted solution]

Hello @Massi1 ,

hhh OK. It is really difficult. I am guessing your data. It would be more efficient to provide the couple of lines with the correct format.

Now, What you are saying is that you don't have a header.

The logic will still work with one little change. Uncheck the first row contains field data option.