Splitting Column without delimiter

[ZubairShalla7]

Hi, I am struggling in splitting a column with the ship names which are repeating without a delimiter. For eg. "KochiKochi". I have a column with multiple vessel names which have the same trend. Any way we can split them and then I can get the actual name of the vessel as "Kochi". I tried created a new column (Column from Examples) but no luck.

[wdx223_Daniel · Accepted solution]

=Text.Start([Vessel],Text.Length([Vessel])/2)

[PijushRoy]

Hi @ZubairShalla7 

Can you please try below code in Custom Column

=let splitColumn1 = Splitter.SplitTextByDelimiter(" ", QuoteStyle.None)([Column1]) in Text.Combine({splitColumn1{0}?, " ", splitColumn1{2}?})

Find the image, and try to use same step

If you face any issue, please share your data in excel format

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS 👍