Since Redshift does not support lookahead assertion, I am in need of a way to find a substring pattern match, however, want to include string up to the pattern match without including the pattern itself.Since Redshift does not support lookahead asser