- the position of @ is not the first character
- .(dot) is not the last character.
- @ is not repeated else where in the string
- Dot is not repeated else where in the string
Monday, 14 November 2016
Validating Email Address in Peoplecode
We have a number of pages in PeopleSoft, where user/admin is free to enter email addresses. How to validate if a value entered in a PeopleSoft field is a valid email address?
In general, how does an email id look like? It will have few characters followed by @ symbol followed by few characters and then a .(dot) symbol followed by few more characters. So, we have to validate the presence of these.
For example, if &email_addr is a variable which contains the string entered in email address field and needs to be validated then try the below code:
&AT = Find("@", &email_addr);
&DOT = Find(".", &email_addr);
If ALL(%AT,&DOT) Then
/* Validation Success */
/* Validation Fail*/
/* Issue Error message */
Additionally we could also perform checks to ensure that:
This can be done by using instr, substr and len functions.
HAPPY LEARNING :)
When inserting rows using PeopleCode, you can either use the Insert method with a record object or create a SQL Insert statement using th...
Creating a Custom Run Control Page This step is the same regardless of whether you will ultimately use the Run Control page with an SQR ...
Dave Duffield and Ken Morris founded PeopleSoft in 1987, when they engineered the company’s first human resources application. Built on a ...
Description: Use the SQLExec function to execute a SQL command from within a PeopleCode program by passing a SQL command string. The SQL...