Regular Expression in reading Address

Help
, , ,
#1

Hi Team,

I have a scenario like. I am reading 5 address lines. In any of the lines i have to find a 5 digit word like DC123 (here DC is static and 123 will be dynamic say i may get DC859, DC254 etc…

In my if condition i have written as ex : item.ToString.Contans(“WC”)
My question is how to append reqular expression after WC which contains 3 dynamic numbers.

  1. Can we put a reqular expression which contains any numerics 1to0 and concatinate with “WC” [or]
  2. Include WC iteslf followed by 1to0 and assign it to a variable and replace it in the above code in “WC”

Can any body provide a need a sample line of code ?

1 Like
#2

Is it always 5 digits? if yes you can find the index of WC or W and take the substring of 5 digits

1 Like
#3

@Robotics

Try below regular expression.

        "DC\d{3}"
1 Like
#4

So this \d{3} will consider only the immediate next 3 digits after DC as numeric right ?

If yes will check and let you know. Also guys provide any other alternate solutions also if

this does not works.

2 Likes
#5

@Robotics

Yes, Exactly.

1 Like
#6

Hi
There are many ways to do it
For example as per your wish with regex
Write this expression directly in a Writeline or assign activity we want
“WC”+System.Text.RegularExpressions.Regex.March(“item.ToString”,”[\d].+”)
This will concatenate any digit value in item.ToStrjng with “WC” like this “WC123” from the string “DC123”

Or
We can use a simple Replace method like this
In a assign activity
“WC” + item.ToString(“DC”,””).ToString

Kindly try this and let know for any queries or clarification
Cheers @Robotics

#7

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