Forum Discussion

pkumarsharma's avatar
pkumarsharma
Regular Visitor
3 years ago
Solved

Text Splitter

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 num...
Need Help
  • slorin's avatar
    slorin
    3 years ago

    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

slorin's avatar
slorin
Icon for Super User rankSuper User
3 years ago

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's avatar
pkumarsharma
Regular Visitor
3 years ago

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