• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Trim Trailing Text

New Here ,
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
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

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

Translate

Translate
Engaged ,
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

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 17, 2006 Dec 17, 2006

Copy link to clipboard

Copied

LATEST
great! that worked out beautifully. tyvm!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Dec 17, 2006 Dec 17, 2006

Copy link to clipboard

Copied

Treat these numbers as space delimited lists.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation