|
This
page provides some useful formulas that can be used in the Data Table.
Any combination of the formulas below is acceptable. The formulas refer
to the data in cell A1 but may be applied to any cell.
For more information on Data Table formulas, refer to Microsoft Excel documentation. All Microsoft Excel formulas can be used in the Data Table.
First word in a sentence:
=LEFT(A1,SEARCH("",A1,1))
First three words in a sentence:
=LEFT(A1,SEARCH("@",SUBSTITUTE(A1,"","@",3),1))
Part of the sentence starting with the fourth word:
=MID(A1,SEARCH("@",SUBSTITUTE(A1,"","@",3),1),LEN(A1))
The part of the sentence starting with "word":
=MID(A1,SEARCH("word",A1,1),LEN(A1))
Check if two strings are equal:
=EXACT(A1,"text2")
Duplicate the string three times:
=REPT(A1,3)
Concatenation of two strings:
="Hello " & "There"
Today's date:
=TODAY()
Generate a random uppercase letter:
=CHAR((
RAND() *26) +65)
http://qtp9.blogspot.com/2007/10/validating-and-passing-data-back-to.html -
The
simple validation example uses a plain button control. If a Submit
control was used, the example would never see the data to check it —
everything would go immediately to the server. Avoiding the Submit
control lets you check the data, but it doesn't submit the data to the
server. That requires an additional line of code:
<SCRIPT LANGUAGE="VBScript">
<!--
Sub Button1_OnClick
Dim TheForm
Set TheForm = Document.ValidForm
If IsNumeric(TheForm.Text1.Value) Then
If TheForm.Text1.Value < 1 Or TheForm.Text1.Value > 10 Then
MsgBox "Please enter a number between 1 and 10."
Else
MsgBox "Thank you."
TheForm.Submit ' Data correct; send to server.
End If
Else
MsgBox "Please enter a numeric value."
End If
End Sub
-->
</SCRIPT>
To send the data to the server, the code invokes the Submit
method on the form object when the data is correct. From there, the
server handles the data just as it otherwise would — except that the
data is correct before it gets there.
-------------
http://www.quick2sms.com - Send Unlimited FREE SMS to Any Mobile Anywhere in INDIA,
Click Here
|