Forum Discussion

DanHuber's avatar
DanHuber
Iron Contributor
Dec 29, 2023

PQ: How to split a large column into 50 characters columns but split only at whitespace?

I have a large table (>80'000 rows) with a column (max width = 163) that I need to resize into smaller columns. The rules are: - split only at whitespaces - column size max 50 characters - 2 colu...
excel
  • DanHuber's avatar
    DanHuber
    Iron Contributor
    Dec 29, 2023

    Thanks Lorenzo 

    I have to admit, I am very hesitant to open an unknown excel file with external data connections on my working environment. I would like, though, since your solution interests me a lot.

     

    Is there any way you could share differently? Perhaps with the M code directly?

     

    I'm just very very careful. Or try to be 🙂

     

    Daniel

     

    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Dec 29, 2023

      DanHuber 

       

      I share your caution and you're absolutely right. Take a look at my profile, nobody complained so far...

      If after that you still hesitate let me know and I'll see what I can do

      • DanHuber's avatar
        DanHuber
        Iron Contributor
        Dec 29, 2023

        Lorenzo , is there a specific reason why your file is using an external data connection?

Resources