Forum Discussion
Find 7# digits in a string
Hi, I have text string where I would like et select numbers only from. And i manage to do that. But it find all the numbers, is it possible to only select the numbers when it is 7 digits concaten...
PeterBartholomew1 I combined the first two "standard GUI" steps (Source and Promote Headers) into one, just for the fact that it's possible. And I wanted to make it shorter.🙂
The SelectNumbers and Exact7 steps use custom columns and require some M coding. But nothing fancy, I dare saying. And my knowledge of M is limited, but Google is great in that aspect, as most problems have been solved already and are documented by somebody, somewhere.
There is definitely confusion on what is wanted here. I also thought it was exactly 7 digit result based on the sample data column labelled "Only 7 digit #" and seeing items #1 and 3 left justified as they were 7 digits long and item #4 right justified as it was >7 digits.
But now looking at the "desired output" column again I note that item #2 was completely blank so maybe the OP wants #1,3,4. So maybe the intent is 7 digits together in a string but that is a problem because #4 'desired output' is NOT 7 digits long. So is the desired output a group of numbers at least 7 digits long?
But now looking at the "desired output" column again I note that item #2 was completely blank so maybe the OP wants #1,3,4. So maybe the intent is 7 digits together in a string but that is a problem because #4 'desired output' is NOT 7 digits long. So is the desired output a group of numbers at least 7 digits long?