RemoveCalcGlobal ( TXTLIST ; RTXTLIST )

Remove Calculation fields and global fields from the field list

Average rating: 4.6 (15 votes) Log in to vote

Manickam - Show more from this author

Sample input:

RemoveCalcGlobal("DataID
G_Field1
LogData
ModStamp
Test_Calc
TheDate
TheNumber
TheText
TheTime
gArchive#; "")

Sample output:

DataID
LogData
ModStamp
TheDate
TheNumber
TheText
TheTime

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let (
       [TXTLISTCOUNT=ValueCount ( TXTLIST );
        TXTLIST1=GetValue ( TXTLIST ; 1 );
        TXTLIST2="*" & Substitute ( TXTLIST ; "¶" ; "**" ) & "*";
        TXTLIST3=Substitute ( TXTLIST2 ; "*" & TXTLIST1 & "*" ; "" );
        TXTLIST4=Substitute ( Substitute ( TXTLIST3 ; "**" ; "¶" ) ; "*" ; "" )
       ];
       Case ( TXTLISTCOUNT > 0 ;
                  
                  If( (PatternCount ( FieldType ( Get ( FileName ) ; TXTLIST1 ) ; "Global" )  + PatternCount ( FieldType ( Get ( FileName ) ; TXTLIST1 ) ; "Storedcalc" ) ) < 1;
                      
                       Let (
                               [RTXTLIST= If ( RTXTLIST="" ; TXTLIST1;RTXTLIST & "¶" & TXTLIST1 )];
                               RemoveCalcGlobal (TXTLIST4;RTXTLIST)
                              )
                      ;  RemoveCalcGlobal (TXTLIST4;RTXTLIST)

                      )
                   ;RTXTLIST)
          )

Remove Calculation fields and global fields from the field list.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

RemoveCalcGlobal ( TXTLIST ; RTXTLIST )

Comments

Support this website.

Support this website.