• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • Last Modified:

Crystal Formula

Hi,

i have field which is coming as below:

Field name: Tag1                                    
 values: 1.000 - 2.000
              3.000 - 5.000    
             10.000 - 32.000

Now i need to show this field called tag1 as 1 - 2, 3 - 5, 10 - 32. ie, need to remove the decimals. But since this field is string type i can't do it. Any ideas.

thanks
0
shirighimire
Asked:
shirighimire
  • 2
1 Solution
 
James0628Commented:
If it's _always_ going to be ".000", you could use

Replace ({Tag1}, ".000", "")

 That will replace every ".000" in the field with nothing (ie. remove those characters).

 If you could have other values (eg. "1.500 - 2.148"), that would be a bit more complicated.

 James
0
 
shirighimireAuthor Commented:
Thanks a ton!!!
0
 
James0628Commented:
You're welcome.  Glad I could help.

 James
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now