EMail Validation for particular Column

Posted by: narayanan on 8 September 2017, 3:07 pm EST

  • Posted 8 September 2017, 3:07 pm EST

    Hi All,

      I am using Far point Version 4.0 .User wants to insert the <b>EMail id </b>the Spread sheet. 

  • Replied 8 September 2017, 3:07 pm EST

    Hello,

    You can use RegularExpressionCellType for that matter as given below:-

                FarPoint.Win.Spread.CellType.RegularExpressionCellType regexcell = new FarPoint.Win.Spread.CellType.RegularExpressionCellType();
                regexcell.RegularExpression = @"^[a-z][a-z|0-9|]*([_][a-z|0-9]+)*([.][a-z|0-9]+([_][a-z|0-9]+)*)?@[a-z][a-z|0-9|]*\.([a-z][a-z|0-9]*(\.[a-z][a-z|0-9]*)?)$";
                fpSpread1.ActiveSheet.Columns[0].CellType = regexcell;

    Hope it helps.

    Thanks,

    Reeva

  • Replied 31 October 2018, 5:44 am EST

    Hello Narayanan, I am trying to validate my email account for particular Column. On the above you have mentioned a statement I have applied but cannot resolve this issue. Please help. If you are trying to Download AOL Gold on your PC then I recommend this site https://www.emailcustomercareservice.com/blog/how-to-download-aol-desktop-gold/
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels