Please help me with this.
It is possible to split field values using a specific character?
Here is my sample table
value
10uF
2K
1.0uF
200UF
I want it to split by this:
value capacitance/resistance
10 uF
2 K
1.0 uF
200 UF
PS: I am using Oracle and the numbers should be separated from letters
Best Answer
Using regular expressions is an option:
here is this example on sqlfiddle Maybe you should improve the regular expression pattern of the number format
Regular expression functions are described here in the manual and on the following pages