Thursday, 4 February 2016

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