Data needs to be stored in line by line

If I understood correctly, you want to store these as separate line items in the DB but have them in one paragraph field in the interface?

yes Mathieu Drouin 

Could you please try the below changed code. Also you can create a rule to do the separation of email ids and call it in your API and as well as here to validate the email addresses. so that you don't have to worry about validating while using this string anywhere else. You can handle it in the interface and make sure the user does not submit an invalid list of email addresses. In this way you don't have to worry about how it is saving in your DB. Because users can enter in  different ways. So, I recommend make use of email identifiers such as .com to find where your text has to be broken into different parts instead of relying on spaces or any other values.

= a!localVariables(
  local!emails: ri!emailAddresses,
  local!individualMail: if(
    a!isNullOrEmpty(local!emails),
    {},
    reject(fn!isnull(_), split(local!emails, "
"))
  ),
  local!invalidEmails: substitute(
    tostring(
      reject(
        fn!isnull(_),
        a!forEach(
          items: local!individualMail,
          expression: if(
            validateemailaddress(fv!item),
            null,
            fv!index
          )
        )
      )
    ),
    ";",
    ","
  ),
  local!validation: if(
    isnull(local!invalidEmails),
    {},
    "Invalid email at " & local!invalidEmails & " position(s) "
  ),
  a!paragraphField(
    label: "Email Addresses",
    labelPosition: "JUSTIFIED",
    placeholder: "Email Addresses should be one per line (can be pasted from Excel)",
    value: ri!emailAddresses,
    saveInto: ri!emailAddresses,
    refreshAfter: "UNFOCUS",
    height: "TALL",
    required: true,
    validations: local!validation
  )
)

Konduru Chaitanya : I have used your above code but getting invalid email even though it is in email format .

Not sure why. I am not getting any errors for the same email address. Could you please share your rule/local variable section with the data. and what is the type for the rule input.

Konduru Chaitanya : emailaddresses is a text type in CDT 

if i add space after emailaddress then i'm not getting any error ,what is need of adding space

Harshit Bumb (Appyzie) said:

a!forLoop()

:raises eyebrow:

Even if calling split() and passing in a *literal linebreak* as the delimiter works (i'd say by accident here), i would strongly advise against this approach as it's not going to be very reliable and, as you can guess from the exchange here, might not be copied over correctly by others.

Instead just do: "split(local!emails, char(10))".

Mike Schmitt 
I agree. Didn't think of it and yeah the literal line break was me being clumsy  I had copied from the previous code I mentioned above. I didn't format.

Konduru Chaitanya :can you please explain why we are using substitute and tostring that part in code

Here's a similar but alternative approach I just typed up, for what it's worth:

a!localVariables(
  local!emailParagraphText,
  
  local!individualEmails: if(
    a!isNotNullOrEmpty(local!emailParagraphText),
    a!forEach(
      split(local!emailParagraphText, char(10)),
      if(a!isNotNullOrEmpty(fv!item), fv!item, {})
    ),
    {}
  ),
  
  local!invalidEmails: a!flatten(a!forEach(
    local!individualEmails,
    if(
      validateemailaddress(fv!item),
      {},
      fv!item
    )
  )),
  
  
  a!paragraphField(
    label: "emails",
    value: local!emailParagraphText,
    saveInto: {
      a!save(
        local!emailParagraphText,
        clean(save!value)
      )
    },
    validations: {
      if(
        a!isNotNullOrEmpty(local!invalidEmails),
        "Invalid emails entered: " & joinarray(local!invalidEmails, ", "),
        {}
      )
    }
  )
)

Here's a similar but alternative approach I just typed up, for what it's worth:

a!localVariables(
  local!emailParagraphText,
  
  local!individualEmails: if(
    a!isNotNullOrEmpty(local!emailParagraphText),
    a!forEach(
      split(local!emailParagraphText, char(10)),
      if(a!isNotNullOrEmpty(fv!item), fv!item, {})
    ),
    {}
  ),
  
  local!invalidEmails: a!flatten(a!forEach(
    local!individualEmails,
    if(
      validateemailaddress(fv!item),
      {},
      fv!item
    )
  )),
  
  
  a!paragraphField(
    label: "emails",
    value: local!emailParagraphText,
    saveInto: {
      a!save(
        local!emailParagraphText,
        clean(save!value)
      )
    },
    validations: {
      if(
        a!isNotNullOrEmpty(local!invalidEmails),
        "Invalid emails entered: " & joinarray(local!invalidEmails, ", "),
        {}
      )
    }
  )
)

will these data also be saved in db as line by line?

Tabassum said:

will these data also be saved in db as line by line?

You're getting ahead of yourself a little bit.  None of this will affect how the data is saved to the DB either way, that is completely separate processing that would need to happen later.  You should work to understand this step fully before moving on to worrying about the DB structure issues.