Sorting by Condition Using MySQL Regular Expressions and Conditional Aggregation

Extracting Specific Columns Based on Character Value in a Row Using dplyr Package