Carot symbot not working

In below regex expression i am getting error

System.Text.RegularExpressions.Regex.Split(output, “^\d{1,4} “,System.Text.RegularExpressions.RegexOptions.None).Where(Function(x) x<>””).ToArray()

error screenshot
image

If i removed carot symbol (^) it is working. In my scenrio i need symbol.

@BNK

In regex Carat and $ symbols not work in some cases.So please provide the input so we will help you to extract the text

I want split the address. this is sample data.

2294 1001000
VIJAY S V .
#55 1800 TH MAIN B-BLOCK
Gobi
Erode 638552
2200 1001000
INDIREA, .
#26, 1612 A BLOCK, SATHA SIVA RAO
Gobi
Erode 638552

@BNK

Could you provide expected output also

Want to update in to Excel
Cell A1: 2294 1001000
VIJAY S V .
#55 1800 TH MAIN B-BLOCK
Gobi
Erode 638552

Cell A2: 2200 1001000
INDIREA, .
#26, 1612 A BLOCK, SATHA SIVA RAO
Gobi
Erode 638552

@BNK


"\d{4}\s\d{6,}[\s\S]*?[A-Za-z]+\s\d{5,}"

image
image

Hi @BNK

Check the below syntax:

[0-9]+[\s\S]*?[A-Za-z]+\s\d+

Regards

For Few records address, name will get in multiple line. few records will get phonno or landline no

for that one this regex not working

Can you provide the sample @BNK

Regards

@BNK

Please provide the input text for that

@BNK

Try with System.Text.RegularExpressions.RegexOptions.MultiLine

cheers