Get numbers as per the number of digits dynamically from Text and Number combined values

[jeongkim]

Hi,

Can we get value dynamically as per how many number or digits the values have?

e.g.

My values have 6 or 7 digits randomly and I hope to get only up to numbers no matter which it is 6 or 7. 

If I use below code then 6 digit values fetch '/' as well which is not needed. 

= Table.AddColumn(#"Removed Other Columns", "Custom", each Text.Start([#"$dn"], 23))

[wini_R · Accepted solution]

Hi @jeongkim,

You might try with extracting the text befoe the (second) delimiter, however I'm not sure if the rule works for other rows as the sampke data is very limited.

If you still want to extract the values based on number of digits you can try with Text.Select and Text.Length functions.

[jeongkim]

Thank you,

It's been resolved by your solution!

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...