Hi,
I have feild in datastage with datatype decimal(9,3) and the values atre like
000000.000
000002.000
000003.100
We want to get rid of these laeding and trailing Zeroes.and the final output we want as
0
2
3.1
Can You tell which function to use or how to achieve this??
thanks in Advance,
Amita
Compress Functionality..help needed
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 12
- Joined: Wed Oct 19, 2005 5:29 am
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Depends on what your output stage is. If seq. file is where you are writing your data, represent the same column as Real(9,3).
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 12
- Joined: Wed Oct 19, 2005 5:29 am
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
If you 'all' want something specific, pls. post your requirement also in detail. In which stage you want to convert, if you want this in the output are you writing this into a seq. stage as .txt?
which we dont want
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 12
- Joined: Wed Oct 19, 2005 5:29 am
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact: