How to display a list that matches the list?

Question

Hello everyone, 
 I am having trouble what function to use. 
 What I am trying to achieve is I have a file name that says NEW_210917. I also have a list NEW_TXT_210917, RNW_TXT_TXT_210917, RPL_TXT_210917 and NEW_TXT_TXT_210917. 
 Regardless of the file names on the list. I need to return the list that has NEW and 210917 on their names. 
 So based on the given above. My result should be NEW_TXT_210917 and NEW_TXT_TXT_210917. 
 Any help will be appreciated. Thank you.

Marco Amador · Accepted Answer

Hi, 
 Using a regular expression would be a good way to accomplish this, like in the following snippet: 
 
 a!localVariables(
 local!test: {
 "NEW_TXT_210917",
 "RNW_TXT_TXT_210917",
 "RPL_TXT_210917",
 "NEW_TXT_TXT_210917"
 },
 a!forEach(
 items: local!test,
 expression: if(
 regexmatch("(NEW)(.*)(210917)", fv!item),
 fv!item,
 {}
 )
 )
) 
 
 I am guessing that probably you don't want to search specifically for "210917", but instead for a given date, and you could also search for the remaining text in a case sensitive way, but you can modify the regular expression string in order to accomplish that if needed. 
 This would require the Regular Expressions functions plugin: community.appian.com/.../regular-expression-functions

How to display a list that matches the list?

Top Replies