Hello friends I wanted to split address, so that enter in data table as per city, zip code, state…etc Exmaple 1: PO BOX 961260 SAN ANTONIO, TX 78269 Example 2: PO BOX 4465 SPRINGFIELD, OH 45501 I am able to split others, only facing an issue in city column its taking hole address…i wante…

Hi @Bot_Learner Checkout this expression System.Text.RegularExpressions.Regex.Match(Stringvariable,”.*(?=,\D)”).ToString.Trim [image] Regards Sudharsan

How to split address to get city

Help Activities

Bot_Learner October 29, 2022, 3:57pm 8

@Sudharsan_Ka thanks for the solution it works for me.

Topic		Replies	Views
Split street, City,state,zipcode from Addresss and load it to the database Activities database , activities , question	25	743	April 19, 2024
Split House Numbers and street address Studio uiautomation	10	603	October 8, 2023
Regex Address Groups Error Activities uiautomation , studio , regex , question	0	488	December 19, 2022
String get fix out put Studio studio , question , extension	3	421	April 2, 2023
Excel: Split A Column Into Multiple Columns Studio studio , question , variables_management	13	3195	October 14, 2021

How to split address to get city

Related topics