Personalization, Customization and Productivity Tools

[4runner]

Hey All, I am using business alerts, and mas90, and sometimes we have orders import where the address line 1 is longer than the allowed characters, thus the apt or STE number get cut off. I'm trying to setup an alert to email when address line 1 > 30 I cannot get it to return a value, I've setup a custom field: LEN("SO_SalesOrderHeader".ShipToAddress1)>20 also tried LEN("SO_SalesOrderHeader".ShipToAddress1) But all I can get is a value of 0 to show up in the alert. Any ideas?

[BigLouie]

How you ever thought of editing the import job so that Address Line 1 is reading a temp field. The temp field is a calculation of the address field in your source file and it is a mid function reading the first 30 characters. Address Line 2 would read the next 30 characters. This way the complete address is written out and not chopped off at 30.