Skip to main content
A
Anonymous
December 17, 2006
Answered

Trim Trailing Text

  • December 17, 2006
  • 2 replies
  • 340 views
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.
This topic has been closed for replies.
Correct answer Stressed_Simon
If you know for sure there will be a space between the whole number and the fraction then use val()

2 replies

D
Dan_Bracuk
Inspiring
December 17, 2006
Treat these numbers as space delimited lists.
S
Stressed_SimonCorrect answer
Inspiring
December 17, 2006
If you know for sure there will be a space between the whole number and the fraction then use val()
A
Anonymous
December 17, 2006
great! that worked out beautifully. tyvm!
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices