Extract text between delimiters, leave text when there are no delimiters

Hello Anonymous 

this is exactly why we have power quer 🙂

you can use Table.TranformColumns and apply there one function to the column "First" like this

{
    {
         "First", 
         each if Text.Contains(_,"(") and Text.Contains(_,")") then Text.BetweenDelimiters(_, "(",")") else _
    }
}

Here a complete example

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WckpLVdBwSs3TVIrVAfJS88C0Y2KigoZjXl4iRNgnsRjOjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [First = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"First", type text}}),
    GetFirstName = Table.TransformColumns
    (
        #"Changed Type",
        {
            {
                "First", 
                each if Text.Contains(_,"(") and Text.Contains(_,")") then Text.BetweenDelimiters(_, "(",")") else _
            }
        }
    )
in
    GetFirstName

that transforms this

into this

Copy paste this code to the advanced editor in a new blank query to see how the solution works.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

Jimmy801 

Thanks for your answer! 
Can U tell me where exactly and what should I paste ? When I try to do it in Advanced Editor, it always gives me an error.

After researching, still don't know what am I doing wrong.

Here is how it looks:

This is the code I see after entering Advanced Editor-without making any changes.

let
    Source = Excel.Workbook(File.Contents("C:\Users\-----------------.xlsx"), null, true),
    #"01.01.2021_Sheet" = Source{[Item="01.01.2021",Kind="Sheet"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(#"01.01.2021_Sheet",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "First"}})
in
    #"Renamed Columns"

Btw. This is the M Language- that is needed in Power Query? Wanna learn it