Solved

How do you subtract part of a data input?

Posted on 2006-11-01
3
191 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
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
ZeonFlash earned 500 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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
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…
This video discusses moving either the default database or any database to a new volume.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now