Forum Discussion

ZubairShalla7's avatar
ZubairShalla7
New Member
2 years ago
Solved

Splitting Column without delimiter

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 ...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

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

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

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 👍