Regex Needed Query

Help Robot
,
1

Hi Team My Input Is
Vendor TaxID-NV055534,Name-Nvidia,Address-Santa Clara,City-California,Country-USA
I want Output after -
For every word I need Regex query Please help

2

Hi,

Can you try the following expression?

yourString ="Vendor TaxID-NV055534,Name-Nvidia,Address-Santa Clara,City-California,Country-USA"

 dict = yourString.Split({","c}).ToDictionary(Function(s) s.Split({"-"c})(0),Function(s) s.Split({"-"c})(1))

Then

dict("Vendor TaxID")
dict("Name")

etc.

Note: dict is Dictionary<string,string> type
Regards,

1 Like
3

Hi @Kuldeep_Pandey

Use the following Regex expression:

Vendor TaxID:

(?<=Vendor TaxID\-)\w+

image
image1431Ă—512 20.7 KB

Name:

(?<=Name\-)[A-Za-z\s]+

image
image1427Ă—500 19.6 KB

Address:

(?<=Address\-)[A-Za-z\s]+

image
image1428Ă—501 20.5 KB

City:

(?<=City\-)[A-Za-z\s]+

image
image1430Ă—502 20.2 KB

Country:

(?<=Country\-)[A-Za-z\s]+

image
image1430Ă—501 19.9 KB

Hope it helps!!
Regards,

4

If you want all the values in one go then try below
(?<=\-).*?(?=\,)

image
image842Ă—184 11.8 KB


If you want one by one then try below
(?<=TaxID-).*?(?=\,)

image
image837Ă—180 10.9 KB

Change the keyword according to your need.

5

Your Address pattern will not work if address is of more than or less than 2 words. Same case go for City as well (except if it is of more than 1 word)

6

Hi @AkshaySandhu

Below regex would work for any number of words:

Address:

(?<=Address\-)[A-Za-z\s]+

City:

(?<=City\-)[A-Za-z\s]+
7

Not Able to Try can you provide xml or SS Of Code

8

Can you explain me both

9

Here you are.Can you try this?

Main.xaml (6.1 KB)

10

Hi @Kuldeep_Pandey

(?<=TaxID-)([A-Z0-9]+)(?=,)
(?<=Name-)([A-Za-z]+)(?=,)
(?<=Address-)([A-Za-z\s]+)(?=,)
(?<=City-)([A-Za-z\s]+)(?=,)
(?<=Country-)([A-Za-z\s]+)

Hope it helps!!

11

If sequence of your required data is fixed i.e. TaxID will always be first, followed by Name, Address etc. then you can try below:

str_TaxID = System.Text.RegularExpressions.Regex.Matches(str_Input, "(?<=\-).*?(?=\,)")(0).Value
str_Name = System.Text.RegularExpressions.Regex.Matches(str_Input, "(?<=\-).*?(?=\,)")(1).Value

etc.

In 2nd option sequence of data does not matter. It will work even if TaxID is at the last position.
Name-Nvidia,Address-Santa,City-New York,Country-USA,TaxID-NV055534

str_TaxID = System.Text.RegularExpressions.Regex.Matche(str_Input, "(?<=TaxID-).*?(?=\,)").Value

I hope this helps.

12

Its Working can you explain me
yourString.Split({",“c}).ToDictionary(Function(s) s.Split({”-“c})(0),Function(s) s.Split({”-"c})(1))

13

Hi,

yourString.Split({",“c}) returns array of string : { “Vendor TaxID-NV055534” , “Name-Nvidia” , “Address-Santa Clara” , “City-California” , “Country-USA” }

Next, ToDictionary is LINQ method to create Dictionary. In this case, key is s.Split({"-"c})(0) (e.g. Vendor TaxID) and Value is s.Split({"-"c})(1) (e.g. NV055534)

Regards,

14

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