I’ve created the following code in a Column Expression node:
if ( arrayContains(columns(columnNames()), "Check Amount: $") )
{
column(arrayIndexOf(columns(columnNames()), "Check Amount: $")+1)
}
This works great at returning the cell to the right of “Check Amount: $”. However, I have a number of files and some of them write that cell without the dollar sign and extra spaces, like: “Check Amount” or “Check Amount:”. Is there a way to add wildcards to this formula, so that ArrayContains looks for something like “Check Amount*”? Or using regular expressions, so it looks for something like:
".*Check Amount.*" ?
I’ve tried combining the RegexMatcher formula with ArrayContains, but I can’t figure out how to do it properly.