How to remove 0 from the text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text field. I want to make a query out of that field without
disturbing the original text field value. I mean that this field will be next
to the original text field in the query

My original text value of the field for example are as follows

09678XV
5689236
056989L
256P89Z

I want to remove the "0" from the start of the text value, the result should
be as follows:

9678XV
5689236
56989L
256P89Z

Its more than 2000 records, which I want to handle very carefullly.

Please advise a solution to this

Regards.

Irshad
 
Irshad said:
I have a text field. I want to make a query out of that field without
disturbing the original text field value. I mean that this field will be next
to the original text field in the query

My original text value of the field for example are as follows

09678XV
5689236
056989L
256P89Z

I want to remove the "0" from the start of the text value, the result should
be as follows:

9678XV
5689236
56989L
256P89Z

Its more than 2000 records, which I want to handle very carefullly.
Click to expand...


You can use a calculated field like this:

newfield: IIf(Left(somefield,1) = "0", Mid(somefield,2),
somefield)
 
I have a text field. I want to make a query out of that field without
disturbing the original text field value. I mean that this field will be next
to the original text field in the query

My original text value of the field for example are as follows

09678XV
5689236
056989L
256P89Z

I want to remove the "0" from the start of the text value, the result should
be as follows:

9678XV
5689236
56989L
256P89Z

Its more than 2000 records, which I want to handle very carefullly.

Please advise a solution to this

Regards.

Irshad
Click to expand...

IIF(Left([SomeField],1)="0",Right$([SomeField],Len$([SomeField])-1))
 
Back
Top