Evaluation of expression failed - RegexReplace

[janszky_nav]

Dear All,

I am using Strong manipulation Node. I try to use a Regex Expression.
regexReplace($new column2$,“.*(\n|.)*Besz.*et.oss.\n” ," " )
This expression delete all text from cells from start to end of the specified lines.

The problem is, one row doesn’t works, and i don’t know why? Previously (Friday) was java.lang.StackOverflowError message.

Thank you.

Tamas

[ipazin]

Hello @janszky_nav,

it’s hard to say by just looking. I suggest to go on https://regex101.com and test it there to see what you are (not) matching properly. Or replace confidential data from that cell with dummy data and share it here

Br,
Ivan

[ArjenEX]

To add to what Ivan already said:

That 7*) in row 169 is probably the reason as it’s different compared to the other rows. Also make sure that you use the correct syntax for the Regex in Java whereby you have to escape special chars, meaning: .*(\\n|.)*Besz.*et.oss.\\n

[janszky_nav]

Dear Ivan,
I tested soon, it’s working.

[janszky_nav]

Dear ArjenEX,

I remove *) characters, but the result unchanged.
I thought about this before because of the special characters.

I thought it was bad because of the length of the text.

Thank you.

[ArjenEX]

In that case, enter rows 145 and 169 in regex101 and see what’s happening and amend your Regex accordingly. If not successful, there is not much else we can do without having an anonymized sample data set/workflow.

[gonhaddock]

Hello @janszky_nav
Could the problem be related to syntax?

Problem: Error while executing regexReplace command

Hi @HeroVax Just to clarify: I supposed that you wanted to remove a line return “\n” - you need two back slashes ahead \\+\n This happens to characters that has a meaning in regex. i.e. If you have a pipe “|” in your text, this symbol means OR in regex. To tell regex that you ar working with a string , then you need to indicate that pipe is a text with a double back slash ahead: \\+| == “\\|” I can’t see further unless you can share some sample of your data. BR

BR

[janszky_nav]

I think, the syntax is ok. I checked in Regex101 too.
I used the Regex Extractor Node.
But doesn’t work there either for this line

[iCFO]

I see a second word at the bottom with partial Regex matches. Is there additional text after which could cause a second Regex match in the same cell?

[janszky_nav]

Dear iCFO,

No. The two words not equal. First spell (B) capital, and the sescond isn’t.
The .oss. is part of (hossza). In the text soesn’t have this word again.

Thank you.

[Daniel_Weikert]

I am not sure this guessing is helping you out. You probably want to provide an (anonymous) sample file for people to test
br

[ipazin]

Hello @janszky_nav,

does it work as expected on regex101? Maybe there is some hidden character that is for some reason breaking regular expression. Try narrowing down where is the issue in cell by removing certain data parts from it.

Br,
Ivan