power query: split text by delimter stop working after certain number of words

[Jeanxyz]

I want to split text in field Work Desc by 

#split= Table.SplitColumn(#"Trimmed Text", "Work Description", Splitter.SplitTextByAnyDelimiter({" ",";",":",",","/", "#(tab)","@","."}, QuoteStyle.Csv))

I notice the split stops after certain words (in image, line 8, split stops after the word "by"). If I filter in line 7 and run the same split code, it seems to work correctly. Is there a bug in M query splitcolumn function?

[Jeanxyz · Accepted solution]

problem solved. Here is the video:  #"Split Column by Delimiter" = Table.TransformColumns(#"Trimmed Text", {"Work Description", Splitter.SplitTextByAnyDelimiter({" ",";",":",",","/", "#(tab)","@","."})}),

help video: https://www.youtube.com/watch?v=bKkXxbOnqxA