Text Splitter

[pkumarsharma]

I want to split text by number of characters but if at that certain position the word is not complete then take it to the end of the word. 

Text	Split by Number of Characters 25	Increase number of characters to 26 to complete the word	Next 25 Characters to start at position 27 and go up by 24 to complete the next word before splitting
The United Nations General Assembly proclaimed 24 January as International Day of Education, in celebration of the role of education for peace and development. The right to education is enshrined in article 26 of the Universal Declaration of Human Ri	The United Nations Genera	The United Nations General	Assembly proclaimed 24

[slorin · Accepted solution]

Add a new column 

Splitter.SplitTextByPositions( 
Table.Group(
Table.FromColumns({{0}&Text.PositionOf([Text]," ",Occurrence.All)},{"Position"}),
{"Position"},
{},
GroupKind.Local,
(x,y)=>if y[Position]>(x[Position]+25) then 1 else 0)
[Position])
([Text])

 Stéphane

[pkumarsharma]

Hi Stephane

Note: in above 25 is replaced with 250. I am trying to build a Twitter auto post generator which is limited by 280 characters in due to character limit of Twitter.

The above custom column produces a list. When I expand it to rows and look at the lenght of the text in some cases it goes over 250. is it possible to limit it to 250 or less

[pkumarsharma]

Stephane, Thanks a million times,