Manipulate String in JAVA?

Question

I have an appointment of SQL that the content brings me so:

[email protected];[email protected]

I only need the first address, I have to disregard everything from the ;?

Answer 1

If you go directly to SQL use a function junction, SUBSTRING and CHARINDEX:

SELECT SUBSTRING(email, 1,CHARINDEX(';', email)-1) from emails;

where email is the field that holds electronic addresses separated by comma and emails the table name.

Withdrawn response: _Soen - How to split a comma-separated value to Columns

---

A suitability to pick up emails that have no items separated by ;, ie only an email contained in the field without ;:

select CASE WHEN Charindex(';', email)>0 
   THEN Substring(email, 1,Charindex(';', email)-1) ELSE
   email END
from emails

_References:

• SUBSTRING (Transact-SQL)
• CHARINDEX (Transact-SQL)
• CASE (Transact-SQL)

Answer 2

There are some ways:

indexed

String result = "[email protected];[email protected]";
int index = result.indexOf(";");
if (index > 0) {
    result = result.substring(0, index);
}
System.out.println(result);

split

String result = "[email protected];[email protected]";
String[] emails = result.split(";");
result = emails[0];
System.out.println(result);

Answer 3

You can use the Java split function to do this.

String email = "[email protected];[email protected]";
String[] emails = email.split(";"); 
System.out.println(emails[0]);

The split function divides a String into several Strings using the given delimiter and returns the parts in a String vector. Since you only need the first, just use:

emails[0]

See working on ideone.