Forum Discussion

lamorim's avatar
lamorim
Frequent Visitor
6 years ago
Solved

Split Column does not split all the data

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?

 

Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    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

     

     

8 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    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

     

     

  • az38's avatar
    az38
    Community Champion
    6 years ago

    lamorim 

    what exactly rows did not split? give an example please