Adobe Community
All community
This category
This board
Knowledge base
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forÂ
ShowÂ
 onlyÂ
|
Search instead forÂ
Did you mean:Â
Global community
Language:
Deutsch
English
Español
Français
Português
日本語コミュニティ
Dedicated community for Japanese speakers
í•œêµ ì»¤ë®¤ë‹ˆí‹°
Dedicated community for Korean speakers
Sign In
Exit
Home
ColdFusion
Discussions
Trim Trailing Text
Home
ColdFusion
Discussions
Trim Trailing Text
0
Upvote
Trim Trailing Text
ryoh
New Here
,
/t5/coldfusion-discussions/trim-trailing-text/td-p/715007
Dec 17, 2006
Dec 17, 2006
Copy link to clipboard
Copied
Hi all,
I have some records with trailing fractions I want to get rid of. For example, "879 1/2", "12345 1/2", and "4512 1/2". Can someone help me "TRIM" the 1/2's off? Thank you very much in advance.
TOPICS
Advanced techniques
Views
247
Translate
Translate
Report
Report
Follow
Report
More
Reply
Reply
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
1 Correct answer
Stressed_Simon
Engaged
,
Dec 17, 2006
Dec 17, 2006
Stressed_Simon
•
Engaged
,
Dec 17, 2006
Dec 17, 2006
If you know for sure there will be a space between the whole number and the fraction then use val()
Votes
0
Upvote
Translate
Translate
Jump to answer
3 Replies
3
Jump to latest reply
Correct answer by
Stressed_Simon
Engaged
,
/t5/coldfusion-discussions/trim-trailing-text/m-p/715008#M66933
Dec 17, 2006
Dec 17, 2006
Copy link to clipboard
Copied
If you know for sure there will be a space between the whole number and the fraction then use val()
Votes
0
Upvote
Translate
Translate
Report
Report
Follow
Report
More
Reply
Reply
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
ryoh
AUTHOR
New Here
,
/t5/coldfusion-discussions/trim-trailing-text/m-p/715010#M66935
Dec 17, 2006
Dec 17, 2006
Copy link to clipboard
Copied
LATEST
In Response To Stressed_Simon
great! that worked out beautifully. tyvm!
Votes
0
Upvote
Translate
Translate
Report
Report
Follow
Report
More
Reply
Reply
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Dan_Bracuk
LEGEND
,
/t5/coldfusion-discussions/trim-trailing-text/m-p/715009#M66934
Dec 17, 2006
Dec 17, 2006
Copy link to clipboard
Copied
Treat these numbers as space delimited lists.
Votes
0
Upvote
Translate
Translate
Report
Report
Follow
Report
More
Reply
Reply
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Post Reply
Preview
Exit Preview
never-displayed
You must be signed in to add attachments
never-displayed
Â
Resources
Documentation
ColdFusion User Guide