rexjc

By a Calculation, Show if any unwanted Type in the email field This is what the Field Does now: Case( Realtors::eMail to Send < 1; TextColor ( "Bad Syntax: empty" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "," ); TextColor ( "Bad Syntax: [ , ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "$" ); TextColor ( "Bad Syntax: [ $ ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "%" ); TextColor ( "Bad Syntax: [ % ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "^" ); TextColor ( "Bad Syntax: [ ^ ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "&" ); TextColor ( "Bad Syntax: [ & ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "*" ); TextColor ( "Bad Syntax: [ * ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "(" ); TextColor ( "Bad Syntax: [ ( ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; ")" ); TextColor ( "Bad Syntax: [ ) ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "&" ); TextColor ( "Bad Syntax: [ & ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "+" ); TextColor ( "Bad Syntax: [ + ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; ":" ); TextColor ( "Bad Syntax: [ : ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "@" ) > 1; TextColor ( "Bad Syntax: 2 [ @ ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "@" ) < 1; TextColor ( "Bad Syntax: No [ @ ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; " " ); TextColor ( "Bad Syntax: [ Space ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "/" ); TextColor ( "Bad Syntax: [ / ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "!" ); TextColor ( "Bad Syntax: [ ! ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "=" ); TextColor ( "Bad Syntax: [ = ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "[" ); TextColor ( "Bad Syntax: [ [ ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "]" ); TextColor ( "Bad Syntax: [ ] ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; ";" ); TextColor ( "Bad Syntax: [ ; ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; "<" ); TextColor ( "Bad Syntax: [ < ] found" ; RGB ( 255 ; 0 ; 0 ) ); PatternCount(Realtors::eMail to Send ; ">" ); TextColor ( "Bad Syntax: [ > ] found" ; RGB ( 255 ; 0 ; 0 ) ); Realtors::eMail to Send > 1; TextColor ( "Syntax OK" ; RGB ( 0 ; 255 ; 0 ) ); )

anybody see a Custom function for checking correct email format?

Anyone know how to export to a EDI 322 file. Electronic Data Interchange (EDI) transmits paper-based instructions and documents electronically (computer-to-computer). EDI is becoming the standard in intercompany transactions, particularly in ordering, distribution, and payable and receivable transactions. EDI allows ASI to communicate with its customers. ASI has established a global information network based on a Sun Microsystems platform and actively communicates with its business partners through networks supported by third-party vendors.

I'm working with Developer 6 in OSX Panther and when I'm in the defining Fields Box and when I choose to delete a Field(s) it takes 4 to 5 min for this to happen. Anyone else having this problem and can it be fix. This is slowing me down working with fileMaker.

Calualation Field: Month(Today) & Day(Today) Result in a Number (11/7/2003 = 117) This Field in the same record should change every day, Tomorrow would be "118". This field keep the number on the day it was created and does not change from day to day. can someone help me.

Is it possible to Import A File With a pipe (|) character as a Field Seperator?

I have a Contact database and a project database. When data is imported into the contact database, the value list in the Project database will not show up till I close FM and restart the computer. On the network this happens only on the Mac OS 9 computers, there is not a problem with the Windows computer. Is there a way to fix this without quitting FM and restarting FM? Thanks, Rex