Split Column does not split all the data

[lamorim]

Hi,

I am working with 3 csv files and have on a text column more than a million rows like this

jornaldenegocios.pt/empresas/industria/detalhe/rei-dos-cogumelos-sob-suspeita

jornaldenegocios.pt/opiniao/colunistas/camilo-lourenco/detalhe/um-toque-de-salazar-para-ganhar-as-eleicoes

When I apply the Split Column by delimiter to the last "/" on the right

There are several rows that does not split.

Any ideia how to solve?

[az38]

@lamorim 

what exactly rows did not split? give an example please

[Mariusz]

Hi @lamorim 

I've tried the example you've given and they split ok.

Can you provide a data sample that includes the examples that do not split?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[lamorim]

I tried this sample data and had the same problem

https://www.dropbox.com/s/tv5kgp2lihsj2bh/Janeiro_sample.csv?dl=0

[Mariusz]

Hi @lamorim 

Some of the string and with "/" therefore it splits it into blank columns

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Mariusz · Accepted solution]

Hi @lamorim 

You can add Custom Column like below, instead of splitting by delimiter.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[lamorim]

Thanks for your help.

It worked.

Do you thing that it is a bug from PowerBi?

[Mariusz]

Hi @lamorim 

No, as explained in the previous post, some of your strings end with "/" and this the delimiter you have used.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[lamorim]

It is strange because I tried to do it with "detalhe/" and the result was the same.

Thanks again