Forum Discussion
Saperate Row value
Hi,
How to split digits if row has digit and text and if therer are no digit cell value should be same like below image
in image red value needs to like green value and non-digit value like non coloured value
Here is one way to do it. Add a custom column with this formula
= List.First(List.Select(Text.Split([location], "-"), each (try Number.FromText(_) otherwise 0) >0))
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
1 Reply
Here is one way to do it. Add a custom column with this formula
= List.First(List.Select(Text.Split([location], "-"), each (try Number.FromText(_) otherwise 0) >0))
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat