Removing first three digits if they are "000"

[stino123]

Hey All,

I have the below order number string of data. In most cases there is three 0's prior to the actual order number however sometimes there is not. Is there a function that removes the first three digits only  if those first three digits are "000"? Thanks in advance!

[CNENFRNL]

Simple Text.TrimStart() is enough,

[stino123]

sorry @amitchandak  still pretty new to power bi what are the functions for: text.start, Then, text replace, else?

Thanks!

[amitchandak]

@stino123 , this is power Query code to be used in Transform data module

Text.Start to get first few character , 3 in this case

Text.Replace will replace data in a text

Text.Start, Text.Middle, Text.End: https://www.youtube.com/watch?v=vky4wPqm0O0 

https://docs.microsoft.com/en-us/powerquery-m/text-replace

Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk

[amitchandak · Accepted solution]

@stino123 , a new column in power query

if Text.Start([Column], 3) = "000" then Text.Replace([Column], "000", "")  else [Column])