All,
I have a sequential file the below data.
100|2.156789345000000
100|2.620000000000000
100|2.234234132423240
100|2.100001000000000
I would like to remove the trailing zero's from the file. is it possible?
Expected Output:
100|2.156789345
100|2.62
100|2.23423413242324
100|2.100001
Inputs are welcome!
suppress trailing zero
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
suppress trailing zero
Karthik
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
Re: suppress trailing zero
Try:
Here, "T" implies Trailing.
Code: Select all
TRIM(YourValue,"0","T")
gateleys
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm