Import CSV seperated by |~ tilde.

[Kroon__]

Hello,

Its my first time on this website but i hope it will help me a lot.

I'am a student in the Netherlands and i study IT with Business Data Management.

We recieved a lot of Data, but the csv is not easy to open in Excel.

I cant give you the real data, but here is a sample of dummy data:

Data of Birth|~|Gender|~|Nationality|~|Student_ID|~~|

Mark the double tilde at the end.

How do i convert this so i will show me just the normal collomns and rows in Excel...

[PFDave]

Select the column, use Text To Columns from the DATA ribbon, choose delimited,NEXT, in other enter ~ then finish

[Kroon__]

This doenst work.

The CSV file clearly has values in it, but when i try to import it with CSV it shows no values

[Kroon__]

This doenst work.

The CSV file clearly has values in it, but when i try to import it with CSV it shows no values

[PFDave]

Can you upload an example and I'll advise from there