Regex pattern not accepted and says identifier expected

Help Activities
, ,
1

Hey all,

(“[^”,]+),([^“]+”)
The above mentioned regex pattern perfectly match my scenario.
but when i pass it in assigne activity = regex.match(input string,“(”[^“,]+),([^”]+“)”)

this is showing identifier error

2

@Oozair_Khan

check this you are using double quotes two times no need

regex.match(input string,“([^“,]+)|([^”]+)").value

if the above mentioned expressions are representing two values means separate with | not with ,

3

Hi @Oozair_Khan

Can you try the below expression once

- Assign -> Output = System.Text.RegularExpressions.Regex.Match(yourstringinput.ToString,“(“[^”,]+),([^“]+”)”).value

The output is a String datatype variable

Hope it helps!!

4

@mkankatala

i did tried yet facing the same issue

5

Then @Oozair_Khan

The problem is trigger from regex code only. Could you provide the screenshot of applying this code on regexr or any any other website.

6

@mkankatala

Screenshot (295)
Screenshot (295)1366×407 37.9 KB

I am basically want to remove , in between " "

7

Okay then use the below expression

System.Text.RegularExpressions.Regex.Replace(yourstringinput.ToString,"(("[^",]+),([^"]+"))","")

Try the above one @Oozair_Khan

8

@mkankatala
nope still facing same issue

1 Like
9

Can you send the error image once @Oozair_Khan

10

The first double quote after the ( is closing the string, not being used as part of the RegEx expression. You have to escape the double quotes inside the string by using two double quotes.

"(""[^"",]+),([^""]+"")"

11

hey @postwick

this worked fine
but when we give two “” its disturbing the regex pattern

(“[^”“,]+),([^”“]+”)
here I want to find , in between “” and then remove it
example string : ```
1070,17,2,GN3-670,“COLLAR B, M STAY”,“2,606.45”

what i need : ```
1070,17,2,GN3-670,"COLLAR B M STAY","2606.45"
12

Why don’t you just use the Generate Data Table activity, since this is CSV data? Then you have it in a datatable and can easily get the values.

Or if you’re just showing us one row but have an entire file to parse, use Read CSV.

13

I’m curious why you’re trying to remove the comma. It’s perfectly valid CSV data, the double quotes tell any CSV parser that the , inside “COLLAR B, M STAY” is data, not a new column identifier.