CSV File unterschiedliche Trennzeichen

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?

Publish

Datasets

Tips and Tricks

R Tool

Calgary

Sharepoint

Prescriptive Analytics

CASS

Accepted answers

ImadZidan

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.

All comments

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.

multisep.yxzp

Massi1

Its not working.

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

ImadZidan

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703