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!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replace * in a data field 1

Status
Not open for further replies.

HEMASUR

Technical User
Jun 3, 2005
28
US
I need to replace an * in a data field

Field1
4541106356*01
15106987 01
1107661*01
99210*01
1108474*01
1108474*02
1108474*03
15608474*04
1108474*05
1108581*01
19097 01
1109541*01

Since the * appears in different places, I am not able to replace with a Concatenate function. Could some one please help me with this.
Thanks a lot.
 
=Replace([strFieldName],"*","")
 
Thanks a lot, it works, I appreciate all your help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top