ksm
Active Member
I have a Who's Who conversion in Enterprise 9.0 (release 9.1.04), basically I'm bringing in phone/fax numbers from an external system (csv) into JDE (Who's Who z-files). Unfortunately the phone/fax numbers in the csv (external system) are not consistently formatted, some have hyphens-dashes but most don't. We need to have all the numbers with hyphen-dashes. Is there a bsfn I can use or do I have to use System (text) functions and count length and insert the hypens-dashes myself? Any suggestions would be very much obliged...