DataStage Scenario #13 - Validate Decimals

Input:

Data
1 2 3 4. 345
423 4w 4232.23
42342.43243
56765.74 545
4 4o 646. 4343
3232. 4232
f432 4.6 66
43 4 6 4.3 3

Expected Output:

Data	Valid
1234. 345	1234.345
4234w4232.23	0
42342.43243	42342.43243
56765.74 545	56765.7455
4 4o 646. 4343	0
3232. 4232	3232.4232
f432 4.6 66	0
43 4 6 4.3 3	43464.33

Like the below page to get update  
https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://groups.google.com/forum/#!forum/datagenx