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

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