Visual Basic

dim strEmail as string, strBefore as string
dim pos as integer 

strEmail = Eddiez@gmail.nl
pos = strEmail.IndexOf("@")
strBefore = strEmail.Substring(0,pos)

dim strEmail as string, strBefore as string
strEmail = Eddiez@gmail.nl
Dim s() as string = strEmail.Split("@"c)
strBefore = s(0)

eg_Anubhava wrote:

Please send me basic idea for writing pdf document.

Richard MacCutchan wrote:

Either way it requires some small effort on your part.

Christian Graus wrote:

And it's clear how that's likely to turn out....

krishnapnv wrote:

oDoc.Bookmarks("Questions").Range.Text = qest

private string GetCellValue(Excel.Worksheet sh,string col,string row)
		{
			// get value from the cell (column,row) 
			Excel.Range excelCell = (Excel.Range)sh.get_Range(col, row);
			if (!string.IsNullOrEmpty(excelCell.Text.ToString()))
				return excelCell.Text.ToString();
			else
			{
				return string.Empty;
			}
		}