csv inport settings

Hi guys,

Simple question i have a macro importer, but i have a new csv format, where the first 4 lines are without delimiter, and the rest has ;

I wanna transpose the 3 lines.

But my importer cannot handle space as demiliter in the first 4 rows, and the ; in the body of the file.

ive added a sample file,

Thanks in advance

invoice_A1247294.csv

Input

Accepted answers

Thableaus

Hi @Hamder83

I`m attaching a solution for you. Let me know if it works.

Cheers,

CSVImporting.yxzp

All comments

grossal

Hi @Hamder83,

I have mocked up an example for you:

The key is to use \0 to import the file without delimiter, so we can process it however we want.

Check out the attached sample workflow and let me know what you think.

Best

Alex

2020-06-16-csv import.yxzp

Thableaus

Hi @Hamder83

I`m attaching a solution for you. Let me know if it works.

Cheers,

CSVImporting.yxzp

Hamder83

Hi both of you

Both solutions works great, so thank you very much!

I was trying to do 2 macro's, one for the top part and one for the bottom joining on file name, but this seems much better.

I have one last question if you have time, I just realized that they have put ="" in many field, which are importet into the flow.

Any way to remome that and read the field as text or?

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235