Regular Expression Functions

RE: Regular Expression Functions

siddharthb0005 — Thu, 07 Dec 2023 13:29:53 GMT

In what format should I pass multiple inputs in string in regexAllMatches, I want to match all patterns for regexmatch without running a loop

RE: Regular Expression Functions

naraharis3752 — Tue, 06 Jun 2023 12:30:12 GMT

how to validations for souce range A1:B1 using regex

RE: Regular Expression Functions

rahult3060 — Fri, 07 Oct 2022 12:45:52 GMT

Can you tell regexmatch cdt and regexmatch fuction are same .Can you please give regexmatch cdt syntax.

RE: Regular Expression Functions

prasanthg0001 — Wed, 22 Jun 2022 09:34:19 GMT

i want phone number in ###-###-#### format, How can i do it in the interface

RE: Regular Expression Functions

Appian AppMarket — Tue, 05 Apr 2022 20:25:31 GMT

Release Notes - v2.2.36

Depreciated RegexMatch CDT
Updated RegexSearch to optionally return match groups, and updated return type to List of Dictionary

RE: Regular Expression Functions

briank0009 — Tue, 29 Mar 2022 13:38:12 GMT

Chris,

I really really need the group captures from regexSearch(). My client doesn't seem to have an agreement to develop & install plugins to their cloud instances.

I was wondering if you could make the necessary changes to your plugin code and get it into marketplace. I fashioned it with what you had already implemented.

First, I created RegexHelperFunctionsGroup.java. It's based off of your RegexHelperFunctions.java. I added the ability to append the captured groups text using "||GRP=>" so the result of a regex search can be easily split() into the matched string, then followed by any captured groups.

What this will mean, you'll need to copy RegexSearch.java to RegexSearchGroup.java and have that call RegexHelperFunctionsGroup.java's Search() instead of RegexHelperFunctions.java's Search() method.

Is this something that can be done asap? Thanks.

RegexHelperFunctionsGroup.java

package com.appiancorp.plugins.regexfunctions.functions;

import java.util.ArrayList;
import java.util.List;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import com.appiancorp.plugins.regexfunctions.pojos.RegexMatch;

public class RegexHelperFunctionsGroup {

public RegexMatch[] Search(String pattern, String searchString, String regexFlags) {
int flags = 0;
boolean returnAfterFirst = true;

for (int i = 0; i < regexFlags.length(); i++) {
switch (regexFlags.charAt(i)) {
case 'i':
flags = flags | Pattern.CASE_INSENSITIVE;
break;
case 'm':
flags = flags | Pattern.MULTILINE;
break;
case 's':
  flags = flags | Pattern.DOTALL;
  break;
case 'u':
  flags = flags | Pattern.UNICODE_CASE;
  break;
case 'x':
  flags = flags | Pattern.COMMENTS;
  break;
case 'd':
  flags = flags | Pattern.UNIX_LINES;
  break;
case 'g':
  returnAfterFirst = false;
  break;
}
}

Pattern p = Pattern.compile(pattern, flags);
Matcher m = p.matcher(searchString);
StringBuffer captures = new StringBuffer();
List<RegexMatchGroup> foundList = new ArrayList<RegexMatchGroup>();
while (m.find()) {

captures.delete(0, captures.length());
for (int i = 1; i <= m.groupCount(); i++) {
captures.append("||GRP=>" + m.group(i));
}

foundList.add(new RegexMatchGroup(m.group() + ((captures.length() > 0) ? captures : null), m.start(), m.end()));

/* If we only wanted the first instance, return after finding it */
if (returnAfterFirst)
break;
}

return foundList.toArray(new RegexMatchGroup[foundList.size()]);
}

}

RE: Regular Expression Functions

briank0009 — Wed, 09 Mar 2022 19:36:24 GMT

Hey Chris,

I'm trying to use regexReplaceAll() to escape the pattern string to make it safe for use with regexSearch().

Unfortunately, I can't seem to make regexReplaceAll() function work. I rather not use sustitute() function for each and every special characters in regular expression.

In function regexReplaceAll(), the replacement string doesn't seem to support the regular expression substitution syntax. I need to be able dynamically escape special characters and I can't seem to be able to dynamically escape characters I'm escaping.

Let me know if there is a way to get it to work in using your library. I'm trying to escape the usual suspects:

., +, *, ?, ^, $, (, ), [, ], {, }, |, \ (not including commas).

Also, I remember using the regular expression plugin twice in the last decade and I remember that version was more like the industry standard regular expression function behavior, similar to one implemented in Java. Am I wrong? Also, could it be possible to be more of a transparent call to how the regular expression works in Java?

Thanks.

RE: Regular Expression Functions

briank0009 — Tue, 08 Mar 2022 02:12:07 GMT

Hey Chris,

In function regexSearch(), do you support returns of the matches with each sub-expression captures broken out? Currently, in the pattern, if I have multiple parenthesized sub-expressions, I get all the matches back in one matches array list with one entry and none of the sub-expression captures are broken out. Just one big run on of what the entire pattern would have matched true if I were using simply regexMatch().

I don't want a boolean back or the entire string that it matched on. That's more work to then parse that out yet a second time. I need the individual captures of each parenthesized sub-expressions returned back from regexSearch().

I am on the Appian Cloud version 21.4 using the regexp plugin 2.1.2.

Thanks.

RE: Regular Expression Functions

Matthias Brixius — Thu, 24 Feb 2022 08:36:53 GMT

Thank you for the plugin. Very helpful!

RE: Regular Expression Functions

vishnud126275 — Wed, 15 Dec 2021 16:42:12 GMT

Hi Chris we have used this plugin in our application. In light of the recent discovery of vulnerabilities with log4j2, we would like to know if this plugin uses the affected version Log4j2, and if yes, would you release an updated version of this plugin to counter the exploit of vulnerability?

RE: Regular Expression Functions

claudio.campisi@keypartner.com — Wed, 13 Oct 2021 12:24:26 GMT

I'm not able to download the plugin. Maybe is due to MFA implemented in last days. I got the following error:

{"resource":"\/suite\/rest\/a\/content\/latest\/isBCLGOdlMUpdGVqW3MCflN3nUZYkriSeIxPHq7TiecbApcLUg34lNQGJP8\/o","error":"APNX-1-4187-000","message":"Authentication failed. Please check your credentials and try again.","title":"An Error Has Occurred"}

RE: Regular Expression Functions

davidn0007 — Thu, 23 Sep 2021 21:57:10 GMT

Apparently it defaults to case insensitive match. I can't find anything that tells how to switch that off.

RE: Regular Expression Functions

Appian AppMarket — Mon, 18 Jan 2021 23:37:50 GMT

v2.1.2 Release Notes

Restructured internal jar to be more inline with other Appian plugins and configured to use gradle for future builds
No functional changes

RE: Regular Expression Functions

Mike Schmitt — Wed, 28 Oct 2020 16:35:38 GMT

Has something happened to "regexIsMatch" in the latest version (2.1.1)? I just updated from 2.0.1 and now all I can see anymore is the older "regexMatch" function. It's making me wonder whether the upgrade is working correctly in the environments I'm trying to manage, because what I'm seeing in my Admin Console no longer matches the function list found in the plug-in description here.

[mention:5d1e0d67ae704e4bbdf450ec817bc8c0:e9ed411860ed4f2ba0265705b8793d05]

RE: Regular Expression Functions

Pietro Rossmann — Tue, 27 Oct 2020 19:58:09 GMT

Hi chris,

What would it take to have also processing of groups?

Especially for replacements?

Can we move this plugin to be compatible with other modern languages?

I have been limited on this with my last 3 projects.