Forum Discussion
vmangalkar
2 years agoNew Member
Issue in adding a custom column which should remove the initial numbers from the start of the string
Hello,
I am facing a issue in adding a custom column which should remove the initial numbers from the start of the string.
| Original Text | Expected Text |
| 19 TestText | TestText |
| 2012 Test Text | Test Text |
| Test Text1 | Test Text1 |
| 1978 TestText 23 | TestText 23 |
In excel I used to do it using formula: [=IF(ISNUMBER(VALUE(LEFT(W2, 1))), MID(W2, FIND(" ", W2) + 1, LEN(W2) - FIND(" ", W2)), W2)]
but in Power Query editor I am not able do so.
Any help is appriciated. Thank you!!
Hello, vmangalkar
Text.TrimStart([Original Text], {"0".."9", " "}))
2 Replies
- AlienSxSuper User
Hello, vmangalkar
Text.TrimStart([Original Text], {"0".."9", " "})) - vmangalkarNew Member
Thank you AlienSx this worked 👍