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.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Note[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]James 11/12 123-456 7 890 Truck[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]1234567890 11/12 James Truck[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]11/12 James 123-45678-90 Truck[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]11/12 James Truck 123 45 678 90[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]11/12 James Truck[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]1 2-3-4 5 6 7-8 9-0[/TD]
[TD]TRUE[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Note[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]James 11/12 123-456 7 890 Truck[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]1234567890 11/12 James Truck[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]11/12 James 123-45678-90 Truck[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]11/12 James Truck 123 45 678 90[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]11/12 James Truck[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]1 2-3-4 5 6 7-8 9-0[/TD]
[TD]TRUE[/TD]
[/TR]
</tbody>[/TABLE]