I have a column that has both numbers and text. I need to get all the numbers ( I could get that with "^\d+$" ) but I also need to include a word that starts with the letter C. Hence I need all numbers and this one row that has a word starting with C.
Help!
thanks-
Solved! Go to Solution.
@vnzboy218 Try this in the regex, parse formula. Is this what you are looking for?
(^[C].*|\d+$)