Conditional formatting

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Conditional formatting

Tas Karas
I have an *author field* which may contain up to 10 names.  I'd like to
create a new field based on the author field which will output like this:




If the *author field* contains more than 6 names, then output as first
author., et al.



Example:

Grothe, B., et al.



If the *author field* contains 6 authors or less, then keep as is:



Example:

Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., & Jacobs, G.






Thanks

Tas
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Conditional formatting

GordonCox
Tas,

I’d certainly look at putting the Authors in a related table, however, the field solution could be something like:

Lets suppose our field, testTable::author, contains “Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., Jacobs, G."
Then


Let (  [
         toList = Substitute ( testTable::author ; ".," ; ". ,¶" ) ;
         countAuthors = valuecount ( toList )
        ] ;

If( countAuthors > 6 ; GetValue ( toList ; 1 ) & " et al." ;
    Substitute ( LeftValues ( toList ; countAuthors - 1 ) ; ". ,¶" ; ",." ) & " & " & GetValue ( toList ; countAuthors )
   )

   )

Will result in "Grothe, B,. Jacobs, G,. Padgett, K,. Aaronson, N. K,. &  Jacobs, G.”

And if the testTable::author field contains "Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., Smith, R.G., James, W.K., Jacobs, G.”

Then the output will be
Grothe, B. , et al.

I’d still advise you to revisit putting the authors in a separate table, but this will work. The issue is that if the names aren’t formatted perfectly, i.e. with “.,” as a delimiter, then it will break.



Regards,

   Gordon Cox
   Enrich Computer Systems
   m: +61 409 88 4920
   e: [hidden email]

> On 9 Jun 2017, at 12:23 pm, Tas Karas <[hidden email]> wrote:
>
> I have an *author field* which may contain up to 10 names.  I'd like to
> create a new field based on the author field which will output like this:
>
>
>
>
> If the *author field* contains more than 6 names, then output as first
> author., et al.
>
>
>
> Example:
>
> Grothe, B., et al.
>
>
>
> If the *author field* contains 6 authors or less, then keep as is:
>
>
>
> Example:
>
> Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., & Jacobs, G.
>
>
>
>
>
>
> Thanks
>
> Tas
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Conditional formatting

Tom Fitch
Another option:

If(
 PatternCount( authors ; ".," ) > 5 ;
 Left( authors ; Position( authors ; ".," ) + 1 ) & " et al." ;
 //else
 authors
)

Tom Fitch
FileMaker Pro Certified Developer
Portland, Oregon


On Thu, Jun 8, 2017 at 10:00 PM, Gordon Cox <[hidden email]> wrote:

> Tas,
>
> I’d certainly look at putting the Authors in a related table, however, the field solution could be something like:
>
> Lets suppose our field, testTable::author, contains “Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., Jacobs, G."
> Then
>
>
> Let (  [
>          toList = Substitute ( testTable::author ; ".," ; ". ,¶" ) ;
>          countAuthors = valuecount ( toList )
>         ] ;
>
> If( countAuthors > 6 ; GetValue ( toList ; 1 ) & " et al." ;
>     Substitute ( LeftValues ( toList ; countAuthors - 1 ) ; ". ,¶" ; ",." ) & " & " & GetValue ( toList ; countAuthors )
>    )
>
>    )
>
> Will result in "Grothe, B,. Jacobs, G,. Padgett, K,. Aaronson, N. K,. &  Jacobs, G.”
>
> And if the testTable::author field contains "Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., Smith, R.G., James, W.K., Jacobs, G.”
>
> Then the output will be
> Grothe, B. , et al.
>
> I’d still advise you to revisit putting the authors in a separate table, but this will work. The issue is that if the names aren’t formatted perfectly, i.e. with “.,” as a delimiter, then it will break.
>
>
>
> Regards,
>
>    Gordon Cox
>    Enrich Computer Systems
>    m: +61 409 88 4920
>    e: [hidden email]
>
>> On 9 Jun 2017, at 12:23 pm, Tas Karas <[hidden email]> wrote:
>>
>> I have an *author field* which may contain up to 10 names.  I'd like to
>> create a new field based on the author field which will output like this:
>>
>>
>>
>>
>> If the *author field* contains more than 6 names, then output as first
>> author., et al.
>>
>>
>>
>> Example:
>>
>> Grothe, B., et al.
>>
>>
>>
>> If the *author field* contains 6 authors or less, then keep as is:
>>
>>
>>
>> Example:
>>
>> Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., & Jacobs, G.
>>
>>
>>
>>
>>
>>
>> Thanks
>>
>> Tas
>> _______________________________________________
>> FMPexperts mailing list
>> [hidden email]
>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Conditional formatting

Beverly Voth-3
In reply to this post by Tas Karas
This is a cross-post with
* https://community.filemaker.com/message/672939

Sent from miPhone

> On Jun 9, 2017, at 12:23 AM, Tas Karas <[hidden email]> wrote:
>
> I have an *author field* which may contain up to 10 names.  I'd like to
> create a new field based on the author field which will output like this:
>
>
>
>
> If the *author field* contains more than 6 names, then output as first
> author., et al.
>
>
>
> Example:
>
> Grothe, B., et al.
>
>
>
> If the *author field* contains 6 authors or less, then keep as is:
>
>
>
> Example:
>
> Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., & Jacobs, G.
>
>
>
>
>
>
> Thanks
>
> Tas
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Conditional formatting

Tom Fitch
Correction:

If(
 PatternCount( authors ; ".," ) > 5 ;
 Left( authors ; Position( authors ; ".," ; 1 ; 1 ) + 1 ) & " et al." ;
 //else
 authors
)

Tom Fitch
FileMaker Pro Certified Developer
Portland, Oregon


On Fri, Jun 9, 2017 at 3:28 AM, Beverly Voth <[hidden email]> wrote:

> This is a cross-post with
> * https://community.filemaker.com/message/672939
>
> Sent from miPhone
>
>> On Jun 9, 2017, at 12:23 AM, Tas Karas <[hidden email]> wrote:
>>
>> I have an *author field* which may contain up to 10 names.  I'd like to
>> create a new field based on the author field which will output like this:
>>
>>
>>
>>
>> If the *author field* contains more than 6 names, then output as first
>> author., et al.
>>
>>
>>
>> Example:
>>
>> Grothe, B., et al.
>>
>>
>>
>> If the *author field* contains 6 authors or less, then keep as is:
>>
>>
>>
>> Example:
>>
>> Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., & Jacobs, G.
>>
>>
>>
>>
>>
>>
>> Thanks
>>
>> Tas
>> _______________________________________________
>> FMPexperts mailing list
>> [hidden email]
>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Conditional formatting

Jonathan Fletcher-2
My way:

Let ( [
        ~list = substitute ( authors ; [ “,. ” ; ¶ ] ; [ “,.” ; ¶ ] ) ;
        ~first = get value ( ~list ; 1 ) & “., et al” ;
        ~all = substitute ( ~list ; ¶ ; “., “ )
] ;
        Case ( ValueCount ( ~list ) > 6 ; ~first ; ~all )
)

This approach (as well as Tom’s) assumes that delimiters will ALWAYS be a period and a comma. If there are ever any other delimiters, or other “accidentals," I would trap for them by adding more substitutions in the ~list calculation.

I like this approach because:
        . It can be made more dependable by filtering the input.
        . You can easily adjust it to output any format you want.

Jonathan




> On Jun 9, 2017, at 7:28 PM, Tom Fitch <[hidden email]> wrote:
>
> Correction:
>
> If(
> PatternCount( authors ; ".," ) > 5 ;
> Left( authors ; Position( authors ; ".," ; 1 ; 1 ) + 1 ) & " et al." ;
> //else
> authors
> )
>
> Tom Fitch
> FileMaker Pro Certified Developer
> Portland, Oregon
>
>
> On Fri, Jun 9, 2017 at 3:28 AM, Beverly Voth <[hidden email]> wrote:
>> This is a cross-post with
>> * https://community.filemaker.com/message/672939
>>
>> Sent from miPhone
>>
>>> On Jun 9, 2017, at 12:23 AM, Tas Karas <[hidden email]> wrote:
>>>
>>> I have an *author field* which may contain up to 10 names.  I'd like to
>>> create a new field based on the author field which will output like this:
>>>
>>>
>>>
>>>
>>> If the *author field* contains more than 6 names, then output as first
>>> author., et al.
>>>
>>>
>>>
>>> Example:
>>>
>>> Grothe, B., et al.
>>>
>>>
>>>
>>> If the *author field* contains 6 authors or less, then keep as is:
>>>
>>>
>>>
>>> Example:
>>>
>>> Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., & Jacobs, G.
>>>
>>>
>>>
>>>
>>>
>>>
>>> Thanks
>>>
>>> Tas
>>> _______________________________________________
>>> FMPexperts mailing list
>>> [hidden email]
>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>> _______________________________________________
>> FMPexperts mailing list
>> [hidden email]
>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

--
Jonathan Fletcher
[hidden email]

Kentuckiana FileMaker Developers Group
Next Meeting: 6/27/17

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Conditional formatting

Jonn Howell at DataExperience
Interesting approach, Dr. Tilde.

;-)

Live life in excellence
- sent from my 1995 Motorola Power PAK bag phone

> On Jun 9, 2017, at 5:03 PM, Jonathan Fletcher <[hidden email]> wrote:
>
> My way:
>
> Let ( [
>    ~list = substitute ( authors ; [ “,. ” ; ¶ ] ; [ “,.” ; ¶ ] ) ;
>    ~first = get value ( ~list ; 1 ) & “., et al” ;
>    ~all = substitute ( ~list ; ¶ ; “., “ )
> ] ;
>    Case ( ValueCount ( ~list ) > 6 ; ~first ; ~all )
> )
>
> This approach (as well as Tom’s) assumes that delimiters will ALWAYS be a period and a comma. If there are ever any other delimiters, or other “accidentals," I would trap for them by adding more substitutions in the ~list calculation.
>
> I like this approach because:
>    . It can be made more dependable by filtering the input.
>    . You can easily adjust it to output any format you want.
>
> Jonathan
>
>
>
>
>> On Jun 9, 2017, at 7:28 PM, Tom Fitch <[hidden email]> wrote:
>>
>> Correction:
>>
>> If(
>> PatternCount( authors ; ".," ) > 5 ;
>> Left( authors ; Position( authors ; ".," ; 1 ; 1 ) + 1 ) & " et al." ;
>> //else
>> authors
>> )
>>
>> Tom Fitch
>> FileMaker Pro Certified Developer
>> Portland, Oregon
>>
>>
>>> On Fri, Jun 9, 2017 at 3:28 AM, Beverly Voth <[hidden email]> wrote:
>>> This is a cross-post with
>>> * https://community.filemaker.com/message/672939
>>>
>>> Sent from miPhone
>>>
>>>> On Jun 9, 2017, at 12:23 AM, Tas Karas <[hidden email]> wrote:
>>>>
>>>> I have an *author field* which may contain up to 10 names.  I'd like to
>>>> create a new field based on the author field which will output like this:
>>>>
>>>>
>>>>
>>>>
>>>> If the *author field* contains more than 6 names, then output as first
>>>> author., et al.
>>>>
>>>>
>>>>
>>>> Example:
>>>>
>>>> Grothe, B., et al.
>>>>
>>>>
>>>>
>>>> If the *author field* contains 6 authors or less, then keep as is:
>>>>
>>>>
>>>>
>>>> Example:
>>>>
>>>> Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., & Jacobs, G.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Thanks
>>>>
>>>> Tas
>>>> _______________________________________________
>>>> FMPexperts mailing list
>>>> [hidden email]
>>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>>> _______________________________________________
>>> FMPexperts mailing list
>>> [hidden email]
>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>> _______________________________________________
>> FMPexperts mailing list
>> [hidden email]
>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>
> --
> Jonathan Fletcher
> [hidden email]
>
> Kentuckiana FileMaker Developers Group
> Next Meeting: 6/27/17
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Conditional formatting

Tom Fitch
In reply to this post by Jonathan Fletcher-2
That's fine but why bother re-constituting the authors field (~all)
when you can just use the field as is? That's what was specified.

Tom Fitch
FileMaker Pro Certified Developer
Portland, Oregon


On Fri, Jun 9, 2017 at 5:03 PM, Jonathan Fletcher
<[hidden email]> wrote:

> My way:
>
> Let ( [
>         ~list = substitute ( authors ; [ “,. ” ; ¶ ] ; [ “,.” ; ¶ ] ) ;
>         ~first = get value ( ~list ; 1 ) & “., et al” ;
>         ~all = substitute ( ~list ; ¶ ; “., “ )
> ] ;
>         Case ( ValueCount ( ~list ) > 6 ; ~first ; ~all )
> )
>
> This approach (as well as Tom’s) assumes that delimiters will ALWAYS be a period and a comma. If there are ever any other delimiters, or other “accidentals," I would trap for them by adding more substitutions in the ~list calculation.
>
> I like this approach because:
>         . It can be made more dependable by filtering the input.
>         . You can easily adjust it to output any format you want.
>
> Jonathan
>
>
>
>
>> On Jun 9, 2017, at 7:28 PM, Tom Fitch <[hidden email]> wrote:
>>
>> Correction:
>>
>> If(
>> PatternCount( authors ; ".," ) > 5 ;
>> Left( authors ; Position( authors ; ".," ; 1 ; 1 ) + 1 ) & " et al." ;
>> //else
>> authors
>> )
>>
>> Tom Fitch
>> FileMaker Pro Certified Developer
>> Portland, Oregon
>>
>>
>> On Fri, Jun 9, 2017 at 3:28 AM, Beverly Voth <[hidden email]> wrote:
>>> This is a cross-post with
>>> * https://community.filemaker.com/message/672939
>>>
>>> Sent from miPhone
>>>
>>>> On Jun 9, 2017, at 12:23 AM, Tas Karas <[hidden email]> wrote:
>>>>
>>>> I have an *author field* which may contain up to 10 names.  I'd like to
>>>> create a new field based on the author field which will output like this:
>>>>
>>>>
>>>>
>>>>
>>>> If the *author field* contains more than 6 names, then output as first
>>>> author., et al.
>>>>
>>>>
>>>>
>>>> Example:
>>>>
>>>> Grothe, B., et al.
>>>>
>>>>
>>>>
>>>> If the *author field* contains 6 authors or less, then keep as is:
>>>>
>>>>
>>>>
>>>> Example:
>>>>
>>>> Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., & Jacobs, G.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Thanks
>>>>
>>>> Tas
>>>> _______________________________________________
>>>> FMPexperts mailing list
>>>> [hidden email]
>>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>>> _______________________________________________
>>> FMPexperts mailing list
>>> [hidden email]
>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>> _______________________________________________
>> FMPexperts mailing list
>> [hidden email]
>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>
> --
> Jonathan Fletcher
> [hidden email]
>
> Kentuckiana FileMaker Developers Group
> Next Meeting: 6/27/17
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Conditional formatting

Jonathan Fletcher-2
Just in case the data isn’t 100% consistent, this way will enable you to accept variety on the input and enforce uniformity on output. Simply add the various deviations to the first line and set your desired outcome in the next two.

Otherwise, you are hard-coding brittleness.

Things like that burn me frequently, because the data supplied by clients is never exactly as it is supposed to be.

Maybe I’m overthinking it, but I’d prefer that to having to go back and tweak a multiple position calculation multiple times. Personally, I find multiple substitutions easier to wrap my brain around than calculating one or more positions for characters that may or may not be there.

But, of course, not everyone has to do it my way. I was just offering it as a different way to solve the problem.


jonathan



> On Jun 9, 2017, at 11:53 PM, Tom Fitch <[hidden email]> wrote:
>
> That's fine but why bother re-constituting the authors field (~all)
> when you can just use the field as is? That's what was specified.
>
> Tom Fitch
> FileMaker Pro Certified Developer
> Portland, Oregon
>
>
> On Fri, Jun 9, 2017 at 5:03 PM, Jonathan Fletcher
> <[hidden email]> wrote:
>> My way:
>>
>> Let ( [
>>        ~list = substitute ( authors ; [ “,. ” ; ¶ ] ; [ “,.” ; ¶ ] ) ;
>>        ~first = get value ( ~list ; 1 ) & “., et al” ;
>>        ~all = substitute ( ~list ; ¶ ; “., “ )
>> ] ;
>>        Case ( ValueCount ( ~list ) > 6 ; ~first ; ~all )
>> )
>>
>> This approach (as well as Tom’s) assumes that delimiters will ALWAYS be a period and a comma. If there are ever any other delimiters, or other “accidentals," I would trap for them by adding more substitutions in the ~list calculation.
>>
>> I like this approach because:
>>        . It can be made more dependable by filtering the input.
>>        . You can easily adjust it to output any format you want.
>>
>> Jonathan
>>
>>
>>
>>
>>> On Jun 9, 2017, at 7:28 PM, Tom Fitch <[hidden email]> wrote:
>>>
>>> Correction:
>>>
>>> If(
>>> PatternCount( authors ; ".," ) > 5 ;
>>> Left( authors ; Position( authors ; ".," ; 1 ; 1 ) + 1 ) & " et al." ;
>>> //else
>>> authors
>>> )
>>>
>>> Tom Fitch
>>> FileMaker Pro Certified Developer
>>> Portland, Oregon
>>>
>>>
>>> On Fri, Jun 9, 2017 at 3:28 AM, Beverly Voth <[hidden email]> wrote:
>>>> This is a cross-post with
>>>> * https://community.filemaker.com/message/672939
>>>>
>>>> Sent from miPhone
>>>>
>>>>> On Jun 9, 2017, at 12:23 AM, Tas Karas <[hidden email]> wrote:
>>>>>
>>>>> I have an *author field* which may contain up to 10 names.  I'd like to
>>>>> create a new field based on the author field which will output like this:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> If the *author field* contains more than 6 names, then output as first
>>>>> author., et al.
>>>>>
>>>>>
>>>>>
>>>>> Example:
>>>>>
>>>>> Grothe, B., et al.
>>>>>
>>>>>
>>>>>
>>>>> If the *author field* contains 6 authors or less, then keep as is:
>>>>>
>>>>>
>>>>>
>>>>> Example:
>>>>>
>>>>> Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., & Jacobs, G.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Thanks
>>>>>
>>>>> Tas
>>>>> _______________________________________________
>>>>> FMPexperts mailing list
>>>>> [hidden email]
>>>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>>>> _______________________________________________
>>>> FMPexperts mailing list
>>>> [hidden email]
>>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>>> _______________________________________________
>>> FMPexperts mailing list
>>> [hidden email]
>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>>
>> --
>> Jonathan Fletcher
>> [hidden email]
>>
>> Kentuckiana FileMaker Developers Group
>> Next Meeting: 6/27/17
>>
>> _______________________________________________
>> FMPexperts mailing list
>> [hidden email]
>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

--
Jonathan Fletcher
[hidden email]

Kentuckiana FileMaker Developers Group
Next Meeting: 6/27/17

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Conditional formatting

eric scheid-5
In reply to this post by Jonathan Fletcher-2

On 12 Jun 2017, at 3:26 pm, Eric Scheid <[hidden email]> wrote:

> On 10 Jun 2017, at 10:03 am, Jonathan Fletcher <[hidden email]> wrote:
>
> ~list = substitute ( authors ; [ “,. ” ; ¶ ] ; [ “,.” ; ¶ ] ) ;


Fletcher probably meant “.,”, not “,.” btw.


>>> Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., & Jacobs, G.

e.

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Conditional formatting

Jonathan Fletcher-2
Yup. Good catch, Eric!


> On Jun 12, 2017, at 1:27 AM, Eric Scheid <[hidden email]> wrote:
>
>
> On 12 Jun 2017, at 3:26 pm, Eric Scheid <[hidden email]> wrote:
>
>> On 10 Jun 2017, at 10:03 am, Jonathan Fletcher <[hidden email]> wrote:
>>
>> ~list = substitute ( authors ; [ “,. ” ; ¶ ] ; [ “,.” ; ¶ ] ) ;
>
>
> Fletcher probably meant “.,”, not “,.” btw.
>
>
>>>> Grothe, B., Jacobs, G., Padgett, K., Aaronson, N. K., & Jacobs, G.
>
> e.
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

--
Jonathan Fletcher
[hidden email]

Kentuckiana FileMaker Developers Group
Next Meeting: 6/27/17

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Loading...