how to fetch data between 'pie' or 'vertical bar' | in database using java?

Question

In database mapRule column contains

IFA 211974009 | Deep partial thickness burn of toe(s) (disorder) |
IFA 28571002 | Second degree burn of toe (disorder) |
IFA 211968009 | Superficial partial thickness burn of foot (disorder) |

required output are in between | symbol pie or vertical bar

Deep partial thickness burn of toe(s) (disorder)
Second degree burn of toe (disorder)
Superficial partial thickness burn of foot (disorder)

how to get this ? i am fetching data from mysql my code is

CODE

<%
    pstm = Con.prepareStatement(selectsql);
    pstm.setString(1, snomedid);
    resultSet = pstm.executeQuery();
    while (resultSet.next()) { %>
        <p><%=resultSet.getString("mapRule")%></p>
    <% } %>

how to validate in this case .?

That looks like a very badly designed database.

Mark Rotteveel
– Mark Rotteveel

2015-12-21 18:43:34 +00:00
Commented Dec 21, 2015 at 18:43 — Mark Rotteveel
– Mark Rotteveel, Commented Dec 21, 2015 at 18:43
yes ! how to remove duplicates in this case @Mark Rotteveel

new learner
– new learner

2015-12-21 18:53:12 +00:00
Commented Dec 21, 2015 at 18:53 — new learner
– new learner, Commented Dec 21, 2015 at 18:53

Timekiller · Accepted Answer · 2015-12-21 15:09:57Z

1

Use String.split, for example. It uses a regular expression as a divider to split your string into array of smaller chunks.

<%
pstm = Con.prepareStatement(selectsql);
pstm.setString(1, snomedid);
resultSet = pstm.executeQuery();
while (resultSet.next()) { 
  String[] chunks = resultSet.getString("mapRule").split("\\|");
  if(chunks.length > 1) { //Don't forget to check that string after first "|" even exists!
%>
        <p><%=chunks[1]%></p>
    <% }
} %>

Also, it might be a good idea to check if resultSet.getString("mapRule") == null if that's possible in your input data.

P.S. It's called a pipe character, not pie.

answered Dec 21, 2015 at 15:09

Timekiller

3,1662 gold badges18 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

new learner Over a year ago

very thanks and its working fine ,i think now it won't need , i ll correct it next time sry for the mistake @Timekiller

new learner Over a year ago

how to avoid duplicates row in this case . am getting duplicates rows

Timekiller Over a year ago

Change your sql query, use distinct for starters. If there are still duplicates it might be necessary to cut the string between | directly in SQL - it's possible using regular expressions or instr and substr. You didn't mention what DBMS you use though, so it's hard to say what would be better to use. Look up how to split a string using delimiter in SQL, there are plenty of relevant answers on StackOverflow.

new learner Over a year ago

am using mysql . and i cant distinct directly because in my case am using only one select query where id ,in that am fetching data one by one based on selecting . so now i confused

Timekiller Over a year ago

Umm, what do you mean you can't use distinct? select distinct mapRule from ..... if that fails, use select distinct substring_index(substring_index(mapRule, '|', 2), '|', -1) from ... - this will cut out value between | directly in mysql and filter out duplicates. You won't need split in Java if you go with the latter.

|

Collectives™ on Stack Overflow

how to fetch data between 'pie' or 'vertical bar' | in database using java?

CODE

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

CODE

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related