How to split units in one field

[vinod2086]

Hi Friends,

i need one help i have one field like

field with unit
OTHERS
33.512
11 Mbps
2 kbps
40.20 gbps
12 gb

but here i want to split field with unit into[ field value] and [field  unit].

Thanks in Advance.

[vinod2086]

Hello Sushil,

as u mentioned code not giving correct results,

am expecting  out put see below table

field_val       unit

Others

33.512

11               Mbps

40.20           gbps.

and am not understanding how to use sub field function in this case.

[Kushal_Chawda]

Try

Subfield ([Field value with unit],' ',1) as FieldValue

Subfield ([Field value with unit],' ',2) as Field with unit

[vinod2086]

...

[IAMDV]

Vinod 4186 wrote:

Hi kush,

i tried above logic but not working

Vinod - How come the above post is the correct answer? Please can you post detailed answer if you know it or mark the correct answer as "correct".

[its_anandrjs]

Hi Vinod,

It seems not good the answer for the question, Some where it is misguide the thread also.

Regards

Anand