How to get text before space from MYSQL to Java

Question

So I have the column 'Adress' which has both street and number in there.
So for example:

 Londonstreet 13

And I got 2 textfields, for street and number which have to get filled up with:

 Street: Londonstreet
 Number: 13

If I do

Street.setText(rs.getString("adress");

It puts 'Londonstreet 13' in the Street textfield, while I want just the streetname.

How to fix this?

http://stackoverflow.com/questions/3481828/how-to-split-a-string-in-java — stdunbar, Jun 14 '16 at 20:00

score 1 · Accepted Answer · answered Jun 14 '16 at 20:13

1

This can be solved using regular expressions

    String address= rs.getString("adress");
    String[] addressPart =address.split("(?<=\\D)(?=\\d)");
    Street.setText(addressPart[0]);
    Number.setText(addressPart[1]);

answered Jun 14 '16 at 20:13

Shersha Fn

1,511
3
26
34

How to get text before space from MYSQL to Java

1 Answers1