Split string with enter key and get only first line

[Rilna_Rilna (Rizzzz)]

I have string separated with enter key. I need to get only single word from second line.
Eg: address
House Number:123
REGION: ABc .
I need only 123 value from this which is house Number. How to fetch this is single line operation rather than splitting to array and looping.

[Yoichi]

Hi,

Can you try the following expression?

System.Text.RegularExpressions.Regex.Match(yourString,"(?<=House Number:)\d+").Value

Regards,

[arivu96 (Arivazhagan A)]

Hi @Rilna_Rilna ,

@Rilna_Rilna

Eg: address
House Number:123
REGION: ABc .

Use regex to extract the data from the string.
(?<=House Number:).*

strHouseNo=System.Text.RegularExpressions.Regex.Match(YourInputVar, "(?<=House Number:).*").Value.ToString()

Regards,
Arivu

[Anil_G]

Hi @Rilna_Rilna

Str.split(“House Number”,2,StringSplitOptions.none)(1).split(environment.newline,2,StringSplitOptions.none)(0)

Cheers

[Rilna_Rilna (Rizzzz)]

Am sorry.i should have made it more clear.
Problem here is there can be multiple house Number in same text and i need house number which is under text address.

address
House number: 123
Region: ABC

New
House Number: 456
Region: DEF

From the above string i need only 123 to be fetched.

[Gokul001 (Gokul Balaji)]

HI @Rilna_Rilna

You can try with Regex Expression

System.Text.RegularExpressions.Regex.Match(yourString,"(?<=address\nHouse\snumber:\s)\d.*").Tostring

Regards
Gokul

[supermanPunch (Arpan)]

Hi @Rilna_Rilna ,

Could you try the below Regex Expression :

(?<=address\nHouse number:).*

[Anil_G]

@Anil_G

Str.split(“House Number”,2,StringSplitOptions.none)(1).split(environment.newline,2,StringSplitOptions.none)(0)

Hi @Rilna_Rilna

Use this

Str.split(“Address”,2,StringSplitOptions.none(1).split(“House Number”,2,StringSplitOptions.none)(1).split(environment.newline,2,StringSplitOptions.none)(0)

Cheers