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/...
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

     

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

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