diff --git a/src/RegexTool.java b/src/RegexTool.java index e2fbe38..d315eef 100644 --- a/src/RegexTool.java +++ b/src/RegexTool.java @@ -78,8 +78,13 @@ private JButton jButton2 = null; private JPanel jPanel = null; private JPanel jPanel3 = null; - private JCheckBox cbMultiline = null; + + private JCheckBox cbMultiline = null; private JLabel lblMultiline = null; + + private JCheckBox cbNulls = new JCheckBox();; + private JLabel lblNulls = new JLabel("Use Nulls?"); + private JLabel lblDirtyHackySpacer = null; /** * This method initializes pnlButtons @@ -97,6 +102,9 @@ this.pnlButtons = new JPanel(); pnlButtons.add(lblMultiline, null); pnlButtons.add(getCbMultiline(), null); + pnlButtons.add(new JLabel(" "), null); + pnlButtons.add(lblNulls, null); + pnlButtons.add(cbNulls, null); pnlButtons.add(lblDirtyHackySpacer, null); this.pnlButtons.add(getBtnMatch(), null); this.pnlButtons.add(getJButton(), null); @@ -460,6 +468,17 @@ Iterator it = this.groupList.iterator(); while (it.hasNext()) { Object[] groups = (Object[]) it.next(); + + // replace empty strings with "null" (handy for DB inserts) + if (cbNulls.isSelected()) { + + for (int i = 0; i < groups.length; i++) { + Object object = groups[i]; + if (object.toString().isEmpty()) { + groups[i] = "null"; + } + } + } this.taFormatted.append(String.format(formatter, groups) + "\n"); } }