Forum Discussion
Pbix_is
Advocate I
Advocate IHow do I determine if value in text type column contains only numbers
Hello! I have a column type text where some values are only numbers and start with many zeros 00000000000123. Other values are text only or are combination of text, characters and numbers; sample: ...
latimeria
Solution Specialist
Solution SpecialistHi Pbix_is ,
Try this:
Table.AddColumn(Source, "Custom", each try Number.ToText(Number.From(Text.TrimStart([Column1],"0"))) otherwise [Column1], type text)
Pbix_isAdvocate I
Advocate IThank you!! It does solve all that I described above!
These came up, however, so I think I will add condition if text contains "E" or "." keep first column.