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 

 

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

 

 

    • 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

       

       

      • Mariusz's avatar
        Mariusz
        Community Champion
        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