Case Sensitive Search in Monarch?

Question

Is it possible to do a search or filter for case sensitive letters? so for instance I have a bunch of addresses and some have Nw and others have NW.

Is there a way to find the ones that have Nw using monarch 13?

Any help is appreciated.

------------------------------
Vaughn Mitchell
Data Analyst
------------------------------

CPorthouse · Answer

Are you using Monarch Classic or Data Prep Studio? I don't have access to v13 anymore and the following is from v14, but I believe the information also worked in your version.  If you are using Classic, you can do a case sensitive search by clicking on the Search binoculars in the ribbon bar under the Table tab:

and then select the "Match Case" check box from the search window that appears below the ribbon bar:

If you want to use a filter, you can may have success using the regular expression functions that are built in.

Go into table design and click Add->Filter:

Assuming your "Nw" criteria is at the beginning of the line, you can use:
RegexIsMatch([Your Column Name],"^Nw")
which will return any row where "Nw" occurs at the beginning of the column "Your Column Name".  Note the caret (^) character in the regular expression.

HTH

------------------------------
Chris Porthouse
Senior Implementation & Integration Engineer
Altair
------------------------------
-------------------------------------------
Original Message:
Sent: 05-24-2019 02:44 PM
From: Vaughn Mitchell
Subject: Case Sensitive Search in Monarch?

Is it possible to do a search or filter for case sensitive letters? so for instance I have a bunch of addresses and some have Nw and others have NW.

Is there a way to find the ones that have Nw using monarch 13?

Any help is appreciated.

------------------------------
Vaughn Mitchell
Data Analyst
------------------------------
"

Stephen_Smay · Answer

Hi Vaughn,

The most current version of Monarch is 15, and I would suggest that you upgrade since V13 is no longer supported.

If you are referring to Monarch Classic, I do not believe we've had enhancements to case-sensitivity, so whatever existed in 13 is probably the same in 15.

With Data Prep Studio V14 and 15 (both currently supported), there are options for filters to be case sensitive or to ignore case and those options are on the filter dialog boxes.

In the scenario you describe, if your end goal is for all the states abbreviations to be capitalized, you can simply right-click on the column and choose Case > Make Upper Case. If your goal is to find the records with improper capitalization, you can make a calculated field that compares the original field value to the "upper" field value and then filter to find zeros where it does not match. That formula would look like this:[State Column] = Upper([State Column])

I hope this helps,
Stephen

------------------------------
Stephen Smay
Director of AMER Solutions Specialists, Data Intelligence
Datawatch Corporation
Bedford MA
(978) 275-8230
------------------------------
-------------------------------------------
Original Message:
Sent: 05-24-2019 02:44 PM
From: Vaughn Mitchell
Subject: Case Sensitive Search in Monarch?

Is it possible to do a search or filter for case sensitive letters? so for instance I have a bunch of addresses and some have Nw and others have NW.

Is there a way to find the ones that have Nw using monarch 13?

Any help is appreciated.

------------------------------
Vaughn Mitchell
Data Analyst
------------------------------
"