Hi Everyone,
Suppose i have a table
Email id
lmn@gmail.com,mno@gmail.com,cst@gmail.com
I want to calculate the number of entries for the object 'email id' for each row.
For the first row the answer should be 2
For the second row the answer should be 1
For the third row the answer should be 3
How can i achieve this by using sap webi functions?
Hi Dibyajyoti,
count the number of occurrences of the @ character per row by comparing the length of the string to the length of the string when the @ characters are removed:
number_of_email_id = Length([email id]) - Length(Replace([email id];"@";"")
This is a solution I saw at http://www.forumtopics.com/busobj/viewtopic.php?p=744945
Best regards,
Thomas
Hi Thomas,
Thanks for your response.
I have created object(number of emailid) using the formula ,number_of_email_id = Length([email id]) - Length(Replace([email id];"@";"").
I have more than 500 rows of data, i want a publication where it will trigger me a mail that "you have used more than 1 emailid in e.g row 4,row 5,row 100.
Regards
Dibyajyoti Pattnaik
There is a solution for your issue.
If a row containing more than 1 mail id, Email can be triggered by replaceing "." with ";"
Hi Dibyajyoti,
with an alerter you could highlight the cells (or rows) that have more than one email_id or use a filter just show these relevant rows. But I am not familiar with publications or triggerings, sorry.
Regards,
Thomas
Hi Dibyajyoti,
The solution for your Question is to count how many "@" available in a row.
You can use the below syntax for achieve the result.
= Length([email id]) - Length(Replace([email id];"@";"")
Correct Answer