How do _i_ remove the last carriage return and all text right of it ?

[robert lewis]

Hello,

 

 

How to simply....  "remove the last carriage return and

all text right of it ?

 

thank you for your time.

 

disable vet

rob

[Wim Decorte]

something like: lefttValues( yourText, valuecount( yourText) - 1 )

[robert lewis]

Dear Philadelphia,

 

geeeeese... of course  _i_ forgot valuecount

 

but....... remain with same problem ....

 

theres one last carriage return siting at the bottom NOT WANT !!

 

 

rob

 

from wawaka Indiana

[Lee Smith]

Do NOT double post your question.

http://fmforums.com/forum/topic/87094-use-selection-to-auto-insert-text-from-list-item/?p=400255

[comment]

theres one last carriage return siting at the bottom NOT WANT !!

 

That is correct: The LeftValues() function, like all xValues functions, leaves a trailing CR. If you don't want it, try =

 

Let (
v = LeftValues ( YourText ; ValueCount ( YourText ) - 1 )
;
Left ( v ; Length ( v ) - 1 )
)

for example, or =

Left ( YourText ; Position ( YourText ; ¶ ; Length ( YourText ) ;  - 1 ) - 1 )

Edited December 22, 2012 by comment

[robert lewis]

Dear Forum,

 

 

Well... Thank you very much !!

 

 

_i_ like Wim Decorte's simplicity:

 

 

lefttValues( yourText, valuecount( yourText) - 1 )

 

And to get a bit esoteric, " _i_  think thats what FileMaker Pro is all about ....

 

... evolving simplicities  (going easy on the brain).  So _i_ will use  Wim Decorte's formula and

 

simply follow it with  ... Case(Right(textField;1)= ¶; Left(textField; Length(textField)-1); textField).

 

Definitely interesting formula equation above ... will save that in my file.

 

AGAIN THANKS AND GOOD DAY !!

 

rob_ert