Hello I want to split the string

Learning & Development Programs Reboot Your Skills 2021
1

Hello,
I want the split string
Input:
main road, Bangalore, KT
main road, Hassan, KT

output:
Banglore, KT
Hassan, KT

2

Hi @copy_writes
use this regex

image
image695×496 23.8 KB

Regards,
Nived N
Happy Automation

3

main road is not same some times it will different
some times i get Bangalore, KT

4

i did not understand @copy_writes

5

main road, banglore, KT
banglore, KT
main street, Hassan, KT

now how to extract

6

(?<=\,).*(?=$)

image

Try the Above expression @copy_writes

7

Can u try this way

image
image917×516 8.11 KB

8

image
banglore is not select

we can use through split if its how

9

If KT will change what we will do

can you please try using Split I don’t no how to use that for that am asking please help me .

10

Can u try this @copy_writes
String.Join(Split(input,Environment.NewLine).Select(Function(r) String.Join(“,”,Split(r,“,”).Where(Function(e) Not e.ToString,Contains(“main”)))))

Just edited @copy_writes

11

@copy_writes ,

Check with this split option

strInput.Substring(strInput.IndexOf(",") + 1)
12

Thank You very much it was simple

and thanks bro for try to give solution @NIVED_NAMBIAR @Pradeep_Shiv every time you both peoples are help me to come out from the solution

13

Always bro @copy_writes,

Happy learning