Split Data - Regular expression exact match

Question

Hi

I am using the split data module in my experiment to filter my data set, what is the regular expression syntax for an exact string match ?

I am using:

\"ColumnA" string

But this does a contains & returns everything with 'string' in it, I want it to return the exact match only eg.

= 'string'

Cheers

Answer 1

Oh I also interested in this one

Answer 2

Hi,

Perhaps you can use the 'Apply SQL Transformation' module to do this filtering of records.

Example:

select * from t1 where t1.make="audi";

Sample experiment:

Regards,
Jaya

Answer 3

You can use the symbol ^ to constrain the search string to the beginning of the string, and the $ symbol to specify that it occur at the end of the string.

For example, this expression returns rows that contain "Fred" anywhere in column myText

\"myText" Fred

This expression returns only the rows where "Fred" occupies all of column myText

\"myText" ^Fred$

Answer 4

Thanks, knew it must have been something straightforward :)

Answer 5

Thanks, missed this module never knew it existed !

Answer 6

Good to hear this helps, thanks for the confirmation.