• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

How do you subtract part of a data input?

I got a field that returns .doc on the end of every piece of data in that field.  I need to subtract the .doc from every piece of data every time it is called.  Does anyone know how to do this.  

Thanks
0
Paulconsulting
Asked:
Paulconsulting
  • 2
1 Solution
 
ZeonFlashCommented:
Where is your "data" coming from?  A dataset?

Dim strName As String = "MyDocument.doc"
strName = strName.Replace(".doc", "")
MsgBox(strName)  'Now has "MyDocument"
0
 
PaulconsultingAuthor Commented:
An access database.

It is being called and returns a value into a label, from that label, I need to subtract part of what is being retuned, and make what is remaining into a string.
0
 
PaulconsultingAuthor Commented:
Thanks, that worked just how I needed it to.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now