?
Solved

How do you subtract part of a data input?

Posted on 2006-11-01
3
Medium Priority
?
233 Views
Last Modified: 2010-04-23
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
Comment
Question by:Paulconsulting
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
ZeonFlash earned 2000 total points
ID: 17852617
Where is your "data" coming from?  A dataset?

Dim strName As String = "MyDocument.doc"
strName = strName.Replace(".doc", "")
MsgBox(strName)  'Now has "MyDocument"
0
 

Author Comment

by:Paulconsulting
ID: 17852663
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
 

Author Comment

by:Paulconsulting
ID: 17852721
Thanks, that worked just how I needed it to.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question