Topic
Text and pattern matching
Parsing, splitting and matching strings that arrived messier than you'd like. Real analyst work, and the questions reward knowing where a LIKE wildcard is anchored and what TRIM actually removes.
New to this? Read the String functions chapter.
easyClean up messy product names99 Speedmart · textFree→easyClean up messy size codesPadini · textFree→easyFind products from a specific brandLazada · textFree→easyFind Toyota listings, regardless of caseCarsome · textFree→easyMerchants on personal email domainsFoodpanda · textFree→easyPull the branch code out of a reference numberCIMB · textFree→mediumExtract the failure reason from a DuitNow error messagePayNet · textFree→hardParse quantity and price out of receipt linesLotus's · textBasic→