Hello,

 

 

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

all text right of it ?

 

thank you for your time.

 

disable vet

rob

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

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

Do NOT double post your question.

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

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, 201213 yr by comment

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