LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: cpapageo

How can i get in output all fields with strings that start with the same characters? (eg Chris, Chris101, ChrisMalc)
Which character can be used for this reason instead of * (that seems it does not work)?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Two ways

emit * where myField.left(5)=="Chris"

or

emit * where myField.regexIsMatch("^Chris*")

=====
For full documentation on the Regex functions, visit pcre.org or http://pcre.org/original/doc/html/

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

There are also the pattern and wildcard operators

emit pattern "Chris.+"

and

emit wildcard "Chris*"

See the pattern and wildcard sections in the Language Elements section of the BRAINScript help.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Adrian is correct if you're looking to select columns by Name...
I was thinking that you wanted specific rows where there is a Value that starts with "Chris"

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: cpapageo

Originally posted by: stonysmith
					

Two ways


emit * where myField.left(5)=="Chris"


or


emit * where myField.regexIsMatch("^Chris*")


=====

For full documentation on the Regex functions, visit pcre.org  or http://pcre.org/original/doc/html/

			

Thank you for the useful tip but I'm trying this:

emit * where 'ACProduct Code' <> "ACM*" and 'ppProduct Code' <> "PPS*"

unsuccessfully...

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

emit * where 'ACProduct Code'.left(3) <> "ACM" and 'ppProduct Code'.left(3) <> "PPS"

or

emit * where not 'ACProduct Code'.regexIsMatch("^ACM*") and not 'ppProduct Code'.regexIsMatch("^PPS*")

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: cpapageo

It worked. Thanks a lot!