csv inport settings

[Hamder83]

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 

[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

[Thableaus · Accepted solution]

Hi @Hamder83 

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

Cheers,

[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?

[Thableaus]

@Hamder83 

You can use a Multi-Field Formula and replace these characters by nothing.

Something like this.

Cheers,

[Hamder83]

Thank you very much 

[grossal]

Hi @Hamder83,

did you took a look at the end result? I already used a Multi-Field Formula to remove these unwanted characters as I thought you probably want to remove them.

I noticed a small mistake on my side and adapted the formula:

Replace(Replace([_CurrentField_], '="', ''),'"','')

Updated file attached. Let me know what you think.

Best

Alex