Forum Discussion

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

Lorenzo

Silver Contributor

Dec 29, 2023

DanHuber

Could you see how it goes with the attached PQ option?

PQ_Split_DanHuber.xlsx20 KB

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
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
  Iron Contributor
  Dec 29, 2023
  Lorenzo , is there a specific reason why your file is using an external data connection?
  - Lorenzo
    Silver Contributor
    Jan 13, 2024
    DanHuber
    In the event where the above does what you expected feel free to Mark it as solution to help people who Search
    Same goes with Split a row into several rows with almost same content. PowerQuery?
    
    Thanks 🙂