Removing Values after the 5 Digits Zip Code

[Sisay_Dinku (Sisay YDG)]

Hi Community

I want to keep only the first five digits of the ZipCode while removing the remaining digits
As you can see on the right side of the following screenshot. Can anyone help with this? Thanks

[Yoichi]

Hi,

Can you try the following expression?

System.Text.RegularExpressions.Regex.Replace(yourString,"-\d+$","")

Regards,

[Nithin_P (Nithin Prabhu)]

Hi @Sisay_Dinku,

Here is a sample workflow. SplitZipCode.xaml (6.5 KB)

Hope that helps !

Regards,
Nithin

[Sisay_Dinku (Sisay YDG)]

Hi @Yoichi
Thanks a lot!
Yes, the expression works. Here is what I’d like to do. I want the Zip Code column to be replaced with the new 5 digits. Can you show me how the flow would go to achieve that?
Remove_four_Digit_From_ZIP.xlsx (9.9 KB)
Please see this attached excel file. Thanks

[Sisay_Dinku (Sisay YDG)]

@Yoichi , I use modern design. Thanks!

[Rahul_Unnikrishnan]

Hello

You can it in multiple ways. 2 methods provided below.

1)By using the regex expression:
System.Text.RegularExpressions.Regex.Match(SampleString,“(\d{5})”).ToString

2)By using the Split method
SampleString.Split(“-”)(0)

Attached the workflow also for your reference.

Demo10.zip (136.1 KB)

Thanks

[Gokul001 (Gokul Balaji)]

HI @Sisay_Dinku

Try with this expression

System.Text.RegularExpressions.Regex.Match(CurrentRow("Postal Code").ToString.Trim,"^\d+").ToString

Check out this XAML file

ForEachRow.xaml (12.5 KB)

Regards
Gokul

[Yoichi]

Hi,

Here you are.

Sample20221201-5.zip (10.4 KB)

Regards,

[Sisay_Dinku (Sisay YDG)]

@Yoichi works fine. Thanks a lot for but the Zip code led by 0, zero gets dropped. I want to keep it.

[Gokul001 (Gokul Balaji)]

HI @Sisay_Dinku

You can ry with Workbook Write range activity

Check out this XAML file

ForEachRow.xaml (14.3 KB)

Output snap

t

[Yoichi]

Hi,

It’s because excel identify this data as numeric.
Can you try to set these cells as text manually in advance?
Or add FormatCell activity as the following?

Sample20221201-5v2.zip (10.6 KB)

Regards,

[Sisay_Dinku (Sisay YDG)]

Hello @Yoichi, that worked perfectly fine for me. Thanks a lot!