The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
Hi Vaughn,
In Classic, you can create a formula-based filter with multiple [Field = "Name*] components.
Give the filter a friendly name, make it active and build the expression:
Name = "John*" .OR. Name = "Matt*"
You can link as many as you need by repeating the pattern.
Name = "John*" .OR. Name = "Matt*" .OR. Name = "Sue*" .OR. Name = "Sophie*"
Note that the Matt* will include 'Matt John' and 'Matthew Jones'. If you didn't want that, you could include the space in the expression "Name = "Matt *"
In Data Prep Studio, we don't have an expression filter, but you can build a 'flag field' using the same technique, then filter on the flag field.
Regards,
Steve.
Hi @Vaughn,I agree with Steve. You can also use RegexIsMatch() and this works quite well.I used this for transactions when I was working at a Financial Institution. It was during the Govt shut down of 2018-2019, and we needed to find some specific transactions to identify which customers were furloughed, based on the deposit transactions (or lack thereof) from the Govt.can you tell us a little bit more about your use case here? I think RegexIsMatch would work well if it's similar to the use case I had.Best Regards,------------------------------Baba MajekodunmiSolutions ConsultantAltair Engineering Inc.Manassas VA2405932495-------------------------------------------------------------------------Original Message:Sent: 07-14-2020 05:26 PMFrom: Vaughn MitchellSubject: How to pull data if it begins with multiple different words?Is it possible to filter a report if it begings with a certain word/cords.So for example if I have a column with a list of names. But I only want to find the names that BEGIN with JOHN and MATT. I have used instr before but I need only the first word.I have monacrh 15------------------------------Vaughn MitchellData Analyst------------------------------"
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…
