referencing charachter sets - Microsoft Access / VBA

Mike

I have a data set that looks similar to the following when cut and
pasted into excel or referenced into access:

1000:24:00
987:24:00
87:24:00
7:24:00

The only data I need is in the first four charachter spaces noted
above. I would like the values to return as follows:

1000
987
87
7

or

1000
0987
0087
0007

Please give this a try. Excel and access want to see it as a TIME
reference.

Thanks...Mike

Nov 12 '05 #1

Subscribe Reply

1455

PC Datasheet

Left([NameOfDataField],Instr([NameOfDataField],":")-1)

Steve
PC Datasheet
"Mike" <mi********@yahoo.com> wrote in message
news:c5**************************@posting.google.c om...

I have a data set that looks similar to the following when cut and
pasted into excel or referenced into access:

1000:24:00
987:24:00
87:24:00
7:24:00

The only data I need is in the first four charachter spaces noted
above. I would like the values to return as follows:

1000
987
87
7

or

1000
0987
0087
0007

Please give this a try. Excel and access want to see it as a TIME
reference.

Thanks...Mike

Nov 12 '05 #2

Similar topics

1243

References referencing array members - how evil is it?

by: Asfand Yar Qazi | last post by:

Hi, I've got this class, you see: class Vec4 { Vec4(); ... float data; float& x;

C / C++

1351

Broken object referencing from within an array?

by: VK | last post by:

.... or my script, or my mind, or both? <html> <head> <title>Test</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <script> function init() { var arr =...

Javascript

298

referencing charachter sets

by: Mike | last post by:

I have a data set that looks similar to the following when cut and pasted into excel or referenced into access: 1000:24:00 987:24:00 87:24:00 7:24:00 The only data I need is in the first...

Microsoft Access / VBA

1282

confused by automatic object de-referencing

by: KavvY | last post by:

Hi, Considering the code posted below can anyone explain to me why the following behaviour occurs? On page load the testFillDataGrid() function gets called and the variable sel is...

C# / C Sharp

1983

Referencing variables on user control pages

by: James Glover | last post by:

I need to be able to reference a variable that is set in the code behind of an aspx page in a user control embedded on the page. An example: The code behind sets a position number; say ,1...

C# / C Sharp

2459

Referencing the Machine Config file

by: Mikey_Doc | last post by:

Hi We are running cms 2002, Framework 1.0 with Visual studio 2002. We have just upgraded to Framework 1.1 and visual studio 2003. All of our database connection strings are stored within the...

ASP.NET

3647

Referencing a tab stop on a subform?

by: ManningFan | last post by:

Here's a fun one, mein froinds! I have a form. The form (call it MainForm) has a subform control (call it SubForm). The actual subform that SubForm displays can change based on choices made on...

Microsoft Access / VBA

2099

Referencing your other assemblies in projects

by: Dave Anson | last post by:

What is the recommended practice for referencing assemblies in a project from other solutions? I am using Visual Studio 2005 Team System. I have several assemblies in another solution which will...

C# / C Sharp

1566

Want to remove an unwanted charachter from scalar

by: ljsmith91 | last post by:

I am reading in a file that has a list that of items. The items I place into a scalar for print but when i do, there is an extra unwanted charachter that shows up at the end of each item. It looks to...

Perl

7009

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

6899

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5475

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4602

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3103

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3094

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1427

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

665

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

302

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General