RegularExpressions.Regex.Split error after migrating to Windows from Windows_Legacy

Help Studio
, ,
1

Hello
I’m migrating my workflow from Windows (Legacy) to a new compatibility type: VB, Windows.
My issue is similar to the one in thread Assign: Expression Activity type ‘VisualBasicValue`1’ requires compilation in order to run
I have got the same error message for assign task: EEIDs = System.Text.RegularExpressions.Regex.Split(AllEEIDs, “[^0-9]+”)
It was working fine in Windows Legacy. Can someone suggest a proper syntax of the clause above?
Are there any guides/rules which should be followed to avoid issues with Assign activity?
Thank you!

2

Hi @Marek_Szwarczewski ,

Could you try re-typing the double quotes in the Expression and Check if it is giving out the same error again ? Or you could try Copy Paste the below Expression :

System.Text.RegularExpressions.Regex.Split(AllEEIDs, "[^0-9]+")
3

Hi @Marek_Szwarczewski

In windows legacy, it seems double quote is normalized and any double quote character is accepted.

Here may the double quotation issue. Can you re enter the expression and check it.

System.Text.RegularExpressions.Regex.Split(AllEEIDs,"[^0-9]+")

Regards
Gokul

4

Thank you @supermanPunch and @Gokul001
You are right. Quotations in the formula was not standard one. After correcting quotation marks activity is working :slightly_smiling_face:

This was clearly visible in Notepad++
image

In Studio quotations look the same but content was not formatted to brown color.
image

Thanks again for your prompt help.
BTW I wonder how this happened as I had lot of quotations and only in this formula, I have used them incorrectly :thinking:

5

Hi @Marek_Szwarczewski

In windows legacy, it seems double quote is normalized and any double quote character is accepted. However, at this time, in windows (.net6) ,in fact, only " (0x22) is accepted to express string literal. To make matter worse, it seems to occur only compiling. (Expression validator don’t raise an alert.)

So you should update the double quotation in all the expression

Regards
Gokul

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.