String Split problem

[Andy Holm]

I have fields that look like this: "M|F".

I want to split that String on the "|". However, it doesn't seem to work when I run the following code:

    
resultsRS.getString("sex_code").split("|");

The result I get is every character (M, |, and F) is in its own array index. What am I doing wrong?

[Henry Wong]

The "|" has special meaning in a regex -- it is a OR operation for search patterns. If you actually want the literal "|", then you need to escape it as "\\|".

Henry