How to update Status as "Bad" for Addresses which are not starting with Number

Help
, , ,
1

Input :

Screenshot (119)
Screenshot (119)1401×513 34.1 KB

I want output like this :
Screenshot (120)
Screenshot (120)1233×572 34 KB

If “Address” starts with only Number, then Status should come as “Good”… if it is not starting with only Number (and if it contains “-” in between) then the Status should come as “Bad”…
It would be really grateful if anyone suggests me some idea on this…I tried using IsMatch condition but not getting correct output…Please recommend any idea.

1 Like
2

@Kavyasri… please check this …

Use the below regex. Count = 1 then good …if not then right bad …

20201125_080907
20201125_0809071080×1031 131 KB

1 Like
3

@prasath17 Thanks for the idea, You mean I need to use like this?

Screenshot (122)
Screenshot (122)1907×991 64.8 KB

4

You can right as shown below…

Regex.Matches(Row(“ColumnName”),“\d±”).Count >= 1) then Good…Else Bad…
image
In the then activity use write cell to write the respective row…use index/counter to increment …

5

Your solution looks good, but I am getting some error when I use that… Previously I used the below process but didnt get exact output…Main.xaml (9.5 KB)

Can you please send me any sample workflow?

1 Like
6

Hello @Kavyasri

  • Use Read Range, and get output like outDt
  • For each row, Pass outDt
  • Use IF Activity like row(“yourColumnName”).ToString.Contains(“-”)

Then: Assign row(“Staus”) = “Bad”
Else: “Address is good”

out side For each row use write range and pass the same path and input as outDt

Cheers
@Kavyasri

7

@Kavyasri

Use IsMatch activity and pass as below

image
image1684×1060 33.8 KB

So the output is a boolean value

image
image1660×348 34 KB

Hope this helps you

Thanks

8

Hi @Kavyasri,

I hope this helps, Fourm.xaml (8.9 KB)

Cheers
@Kavyasri

9

@Kavyasri
Regex Ismatch with following pattern:
grafik

^\d+\b

^ for begin
\d+ for 1 or more digits
\b word end
\ (Space) to exclude the -

2 Likes
10

Hi @Pradeep_Shiv, thanks for replying… My query is : I want Address as “Bad” if it is not having only Number at starting… For ex: if Address is "1234 Ab colony " then Status is “Good”, if “Address” is “Charles 2nd Street” then “Status” is “Bad”… Likewise if Address is “234-866 Bluecross Area” then also it is “Bad” because ‘-’ is there in between number…You said solution only for ‘-’, but my doubt is different.

11

@Kavyasri

Can you share the sample excel file

Thanks

1 Like
12

@Srini84, I tried this…not getting exact output

13

@ppr - I am trying to improvise the solution…Saying if there is a space come after number and then followed by - , then the address is still bad right?

So i have added as shown below…But its selecting the 4th one also…how do I restrict to begin of the string…i tried ^ it is not working…Please advise.
image

1 Like
14

@Srini84, Excel file
trial1.xlsx (8.7 KB)
My process
Main.xaml (9.5 KB)

15

Hello @Kavyasri,

Use the pattern mentioned by @ppr,

Cheers

1 Like
16

Hi @Kavyasri,

Fixed it trial1.xlsx (9.1 KB) TestExcel.xaml (9.5 KB)

Cheers

2 Likes
17

Just change the Cell value there,

1 Like
18

@ppr Now I tried this
Main.xaml (9.5 KB)
But I am not getting output exactly…Getting like this

Screenshot (124)
Screenshot (124)1132×543 32 KB

But I want Status as “Bad” for "928-3313 Vel Av.Idaho Falls " and “711-2880 Nulla St.Mississippi 96522” …Because ‘-’ is there in between.

1 Like
19

Hello @Kavyasri,

Please try this code and let me knowTestExcel.xaml (9.5 KB)

Cheers

20

@Kavyasri

as mentioned above. Have a look below:
grafik

it is not matching so status is bad

1 Like