Power Query - Remove every N characters in field/column

[dcbuzzell]

I have a field in my data that is actually comprised of multiple fields from the original data (which I can't access). A series of 70 character strings are strung together to create my field, but in the process a space is added between the original fields. I'd like to figure out how I can remove that space that occurs after 70 characters - so characters, 71, 142, 213, etc. in each record of a column.

An example string/record:
Clean out sump closet
Clean exterior flat work
Clean unfinished baseme nt area
Clean out cabinets at basement bar, clean countertops
Clean tr acks of sliding glass doors throughout, difficult to operate
Clean fro nt porch, check for defects

In essence, I want to fix the spelling of "basement," "tracks," and "front"

I apologize if this was posted elsewhere, my search didn't turn up results.

 

[JGordon11]

Book1
	A	B	C	D
1	Column1		Column1
2	Clean out sump closet Clean exterior flat work Clean unfinished baseme nt area Clean out cabinets at basement bar, clean countertops Clean tr acks of sliding glass doors throughout, difficult to operate Clean fro nt porch, check for defects		Clean out sump closet Clean exterior flat work Clean unfinished basement area Clean out cabinets at basement bar, clean countertops Clean tracks of sliding glass doors throughout, difficult to operate Clean front porch, check for defects
3
Sheet1

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    tbl = Table.TransformColumns(Source, {"Column1", each 
            let 
                len = Text.Length(_),
                lst = List.Reverse(List.Generate(()=>70, (x)=> x <= len, (x)=> x + 71))
            in  
                List.Accumulate(lst, _, (s,c)=> Text.RemoveRange(s,c,1))
    })
in
    tbl

 

[dcbuzzell]

Book1
	A	B	C	D
1	Column1		Column1
2	Clean out sump closet Clean exterior flat work Clean unfinished baseme nt area Clean out cabinets at basement bar, clean countertops Clean tr acks of sliding glass doors throughout, difficult to operate Clean fro nt porch, check for defects		Clean out sump closet Clean exterior flat work Clean unfinished basement area Clean out cabinets at basement bar, clean countertops Clean tracks of sliding glass doors throughout, difficult to operate Clean front porch, check for defects
3
Sheet1

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    tbl = Table.TransformColumns(Source, {"Column1", each
            let
                len = Text.Length(_),
                lst = List.Reverse(List.Generate(()=>70, (x)=> x <= len, (x)=> x + 71))
            in 
                List.Accumulate(lst, _, (s,c)=> Text.RemoveRange(s,c,1))
    })
in
    tbl

Excellent! Thank you very much. I thought right after that I could split the column into 8 separate columns, trim the last character, then combine it back, but this is obviously much cleaner. I'll have to study to understand just what is going on here. This solves a minor irritant, much appreciated!