AnsweredAssumed Answered

notation format

Question asked by FrederikPieraerd on Nov 17, 2014
Latest reply on Nov 18, 2014 by philmodjunk

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

Outcomes