Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
8 years ago
Solved

Power Query | Insert a character to a string

Is there a way to insert a character into a string, for example I'm working with a time which is in HHMM format

so I want 0730 to become 07:30 or 0915 to become 09:15.

 

The solution I have right now is to split the text into 2 and then merge with the colon in between.

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi ovetteabejuela,

     

    Add a custom column via Text.Insert function.

    = Table.AddColumn(Source, "Custom2", each Text.Insert(Text.From([Column1]),2,":"))

     

    Best regards,

    Yuliana Gu

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi ovetteabejuela,

     

    Add a custom column via Text.Insert function.

    = Table.AddColumn(Source, "Custom2", each Text.Insert(Text.From([Column1]),2,":"))

     

    Best regards,

    Yuliana Gu