Hi there,.

I've a calculation result that I need to have cleared of hard returns,
replacing them with soft returns.   Can this be done in a calulation?
FMPro only has hard returns displayed as optional in the calc field.

I am on a Mac.

phellard@gmail.com wrote:
> Hi there,.
> 
> I've a calculation result that I need to have cleared of hard returns,
> replacing them with soft returns.   Can this be done in a calulation?
> FMPro only has hard returns displayed as optional in the calc field.
> 
> I am on a Mac.
> 
I haven't tried this but from my dark past, I recall that each character 
was assigned a number and that on a pc at least if you held down the alt 
key and typed in the code on the numeric keypad, you got the character 
on the screen as if you had typed it. This includes hard returns which 
is <Alt+32> I think. Anyway, find our the ascii character of the soft 
return and do a find&replace.
Bignoel

In article <1142817193.907084.262180@z34g2000cwc.googlegroups.com>,
"phellard@gmail.com" <phellard@gmail.com> wrote:

> Hi there,.
> 
> I've a calculation result that I need to have cleared of hard returns,
> replacing them with soft returns.   Can this be done in a calulation?
> FMPro only has hard returns displayed as optional in the calc field.
> 
> I am on a Mac.

I'm not sure if it'll work (I'm not even sure if FileMaker can store
soft-returns), but you can try ...

    - Create a new Global field (Text type) called 
      g_SoftReturn, temporarily put it on any layout and 
      type in a "soft return" - usually that's obtainable
      by pressing shift-return.

    - Your calculation can now use:
          Substitute (OriginalText, "�", g_SoftReturn)

That should work, if it's going to work in any way at all.

If FileMaker can't type the soft-return you can try typing it in
another application (MS Word, PageMaker, InDesign, etc.) and then
copy-pasting it into FileMaker.

Helpful Harry                   
Hopefully helping harassed humans happily handle handiwork hardships  ;o)