joshbjames
New Member
- Joined
- Jul 25, 2017
- Messages
- 33
I have a column of data with no particular structure to the characters. They are notes containing combinations of dates, model numbers ect... I'd like to find just the strings of 10+ numbers. Sometimes the numbers are consecutive, sometimes separated by a "-", "/" or " ". Below is an example of the results Id like. I will bold the text that triggers the flag.
<tbody>
</tbody>
Note | Result |
James 11/12 123-456 7 890 Truck | TRUE |
1234567890 11/12 James Truck | TRUE |
11/12 James 123-45678-90 Truck | TRUE |
11/12 James Truck 123 45 678 90 | TRUE |
11/12 James Truck | FALSE |
1 2-3-4 5 6 7-8 9-0 | TRUE |
<tbody>
</tbody>