This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
True story, yesterday I created a workflow that scraped the history of community posts (sorry community admins!) so I can work out the optimal days and times to hang out on the forum to solve problems.
I may blog about this but here's some early insight (times in UTC) - hotter zones are where the most problems are posted to the Designer forum:
The .* means 0 or more of whatever character and the \d+ means at least one digit (number). Overall, the expression is saying look for at least one digit somewhere in your record. If it finds one, it will come out the true side of the Filter. The reason this works here is because we are under the assumption that your "NA" records will not also contain numbers.
@BarnesK - if i just had \d+ if would look for any cell with at least one digit right? Does that include 0? Further, what is the need .*? Can't i just had the \d+ and it will automatically find any cell with an integer?
Yes, it would include 0 if you just had \d+. The reason I added the .* is in the case there were any numbers with decimal points. If you only had \d+, it would only keep whole numbers. Technically since the decimal point would come first, you wouldn't need the second .* and could just use the expression
Yet another option would be
Which is saying look for 0 or more digits then an optional decimal point (we are telling Alteryx that it is optional by putting the question mark after it and we have to put the \ before it to tell Alteryx that it is looking specifically for the decimal point and not just any character) finally followed by at least one digit.
It all depends on how specific you want to get and what your data looks like! :)