Skip to Content
avatar image
Former Member

I have a requirement to calculate number of entries in a row in sap webi.

Hi Everyone,

Suppose i have a table

Email id

abc@gmail.com,xyz@gmail.com

def@gmail.com

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 06, 2017 at 11:12 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      There is a solution for your issue.

      If a row containing more than 1 mail id, Email can be triggered by replaceing "." with ";"

  • avatar image
    Former Member
    Jul 17, 2017 at 07:26 AM

    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];"@";"")

    Add comment
    10|10000 characters needed characters exceeded