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 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.

 

 

Need Help

2 Replies

  • PijushRoy's avatar
    PijushRoy
    Community 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 👍