Displaying text in a datagrid without zeros!

arneweise77 · Jun 17, 2002

Hi!

I need to solve this problem!
Having a text, let´s say 0000478564, retrieved from access and displayed in a datagrid. I need to remove or in some way get rid of the first 4 zeros.
Is there a function for this problem? or a sqlcommand to solve this.

Thanks in advance!

Arne

Dynapen · Jun 17, 2002

If you have the field set as numeric, then it will automatically strip off the leading zero's. The money's gone, the brain is shot.....but the liquor we still got.

onpnt · Jun 17, 2002

or you could get rid of them after you retrieve them from the DB with something like this
<HTML>
<HEAD><TITLE></TITLE>
<SCRIPT LANGUAGE="VBScript">
<!--
Sub extract()
Dim TheForm, MyVar
TheForm=form1.Text1.value
'Start by trimming leading/trailing spaces

'Now, replace spaces...
Do While InStr(1, TheForm, "0&quot

TheForm = Replace(TheForm, "0", "&quot

Loop
MyVar = MsgBox ("Here it is without zeros " & TheForm)
End Sub

-->
</SCRIPT>
</HEAD>
<BODY>
<H3>Simple Validation</H3><HR>
<form Name="form1">

<input TYPE="TEXT" name="Text1" SIZE="30">
<input TYPE="button" VALUE="reformat" onClick="extract()">
</form>
</BODY>
</HTML> I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Displaying text in a datagrid without zeros!

arneweise77

Programmer

Dynapen

Programmer

onpnt

Programmer

Similar threads

Part and Inventory Search

Sponsor