An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
I am trying to filter rows in a dataset that contain characters such as ' | and @. Which operator is best suited to this and also how would this regular expression be be written?
In the following I generate examples with value1..value10 as attribute values throughout. Then value1 and value2 have the offending characters inserted. Finally a regex replacement finds those edits and sets them to missing values, and examples with missing values are trashed.
In the following I generate examples with value1..value10 as attribute values throughout. Then value1 and value2 have the offending characters inserted. Finally a regex replacement finds those edits and sets them to missing values, and examples with missing values are trashed. If you play around with the ( new in V5 ) regex parameter editor you'll soon see just how useful, but impenetrable, regex can be.