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!

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

Remove period from middle of value

Status
Not open for further replies.
luxvivens

luxvivens

Technical User
Joined
May 20, 2010
Messages
27
Location
CA
I am using CR10.
I have data as follows: (fieldname.ICD10):
OSRA90.23BC
OSRA22.55JX

I wish to convert these values to:
OSRA9023BC
OSRA2255JX

Need help with a formula to do this.
 
Sort by date Sort by votes
Thanks kray.
I replaced the comma with a . and it worked perfectly.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question Question
Running total from a subreport only showing last value
Replies
4
Views
1K
doodledump
D
Corinne30
  • Locked
  • Question Question
Running total based on beginning parameter value
Replies
0
Views
363
Corinne30
Corinne30
Corinne30
  • Locked
  • Question Question
Running total based on beginning parameter value
Replies
0
Views
368
Corinne30
Corinne30
B
  • Locked
  • Question Question
Difference of a field between 2 variable dates
Replies
1
Views
625
hilfy
hilfy
socalvelo
  • Locked
  • Question Question
Extract Phone Numbers from Text Field
Replies
0
Views
716
socalvelo
socalvelo

Part and Inventory Search

Sponsor

Back
Top