1 Reply Latest reply on Nov 18, 2014 7:12 AM by philmodjunk

    notation format

    FrederikPieraerd

      Title

      notation format

      Post

      Best I found this wonderful script forum, unfortunately I manage my table address field address Delete :: Telephone 2

      I want to link this script to the address field // mail :: Telephone2 (for Begium issues)

      ADRES::Telefoon 2 
      Let ( [
      input = GetAsText ( Filter ( tel ; "0123456789" ) ) ;
      chk9 = Length ( input ) = 9 ; 
      chk10 = Length ( input ) = 10
      ];

      Case 
      ( input = "000000000" ; TextColor ( "000/000.000" ; RGB (0 ; 0 ; 0 ));
      (not chk9 and not chk10) or ( Left (input ; 2 ) ≠ "02" and Left (input ; 2) ≠ "03" and Left (input; 2 ) ≠ "04" and Left (input ; 2) ≠ "09" and Left (input ; 2 ) ≠ "01" and Left (input ; 2) ≠ "05" and Left (input; 2 ) ≠ "06" and Left (input ; 2) ≠ "07" and Left (input ; 2) ≠ "08") ; TextColor ( tel ; RGB ( 220 ; 0 ; 0 ) ) ;

      (Left (input ; 2 ) = "02" or Left (input ; 2) = "03" or Left (input; 3 ) = "042" or Left (input; 3 ) = "043" or Left (input ; 2) = "09") and (Land = "") and chk9 ;
      TextColor (Left ( input ; 2 ) & "/" & Middle ( input ; 3 ; 3 ) & "." & Middle ( input ; 6 ; 2 ) & "." & Middle ( input ; 8 ; 2 ) ; RGB (0;0;0));

      (Left (input ; 2 ) = "01" or Left (input ; 2) = "05" or Left (input; 2 ) = "06" or Left (input ; 2) = "07" or Left (input ; 2) = "08") and (Land = "") and chk9;
      TextColor (Left ( input ; 3 ) & "/" & Middle ( input ; 4 ; 2 ) & "." & Middle ( input ; 6 ; 2 ) & "." & Middle ( input ; 8 ; 2 ) ; RGB (0 ; 0 ; 0 ));


      (not chk10 or ( Left ( input ; 3 ) ≠ "047" and Left ( input ; 3 ) ≠ "048" and Left ( input ; 3 ) ≠ "049" ) ); TextColor ( tel ; RGB ( 220 ; 0 ; 0 ) );
      ( Left ( input ; 3 ) = "047" or Left ( input ; 3 ) = "048" or Left ( input ; 3 ) = "049" ) and (Land = "") and chk10 ;
      TextColor (Left ( input ; 4 ) & "/" & Middle ( input ; 5 ; 2 ) & "." & Middle ( input ; 7 ; 2 ) & "." & Middle ( input ; 9 ; 2 ) ; RGB (0; 0; 0));
      TextColor ("000 000 000" ; RGB (225 ; 0 ; 0 ))

      )
      )

       

      viewtopic.php? f = 23 & t = 5938 & p = 36929 & Hilit = telefoonnummer # p36929

       

      Thanks

       

      Frederik