Address Extraction

Question

I want to extract the all addresses from this string. The regex should be generic.

Input string:

ABC MEDICAL CENTER
PO BOX 134
WILSON, NC 27234
SIVER BANK
4235 EXECUTIVE SQ STE 140
LAY JOLLA GA 22037ABC MEDICAL CENTER
PO BOX 134
WILSON, NC 27234
ABC MEDICAL CENTER
P.O.BOX 1624
MILSON, NC 2084
ABC MEDICAL CENTER
P.O.BOX 1689
MILSON, NC 20834
ABC MEDICAL CENTER
P.O.BOX 1625
MILSON, NG 27812

I missed the uipath tag, your problem has a solution [here](https://forum.uipath.com/t/split-string-by-comma-and-assign-substrings-to-variables/83803) — Ankit, May 26 '20 at 13:46
Hi, welcome to SO. What have you tried? Take a look at [how-to-ask](https://stackoverflow.com/help/how-to-ask) — Francesco, May 26 '20 at 13:59

score 0 · Accepted Answer · answered May 26 '20 at 13:32

You can use String.split() function or StringTokenizer class to split a comma separated String in Java.

import java.util.Arrays;   
public class Main
{ 
  public static void main(String[] args)     
     {   
       String CSV = "Google,Apple,Microsoft";   
       String[] values = CSV.split(",");   
       System.out.println(Arrays.toString(values));   
     } 
}
Output :[Google, Apple, Microsoft]

You can also create an ArrayList by splitting a comma separated String as shown below:

ArrayList list = new ArrayList(Arrays.asList(values)

If your comma separated String also contains whitespace between values, then you can use the following regular expression to split the CSV string as well as get rid of the leading and trailing whitespaces from individual values.

String CSV = "Google, Apple, Microsoft";
String[] values = CSV.split("\\s*,\\s*");
System.out.println(Arrays.toString(values));

Here \\s* is the regular expression to find zero or more space.
\s is the metacharacter to find whitespace including tabs, since \ (forward slash) requires escaping in Java it becomes \ (double slash) and \s becomes \s. Now coming to * (star or asterisk), it's another special character in regular expression which means any number of times. So \\s* means space any number of times.

sometimes in address there is no separator like comma, in that time how to work on this. — learner, May 27 '20 at 08:26
You need to find a specific pattern that repeats after each address, it can be number of lines for each address or number of white spaces, it all depends on the data. — Ankit, May 27 '20 at 09:17

Address Extraction

1 Answers1