By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,735 Members | 1,286 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,735 IT Pros & Developers. It's quick & easy.

extracting numeric values from text record set

P: 1
Hi,

Please forgive my ignorance as i am a newbie on Access .

I have a field on in my table called Sch_Data with the following record .

3;875;646;697;1
3;875;712;770;1
3;53;880;893;1
4;4;697;712;1
4;6;780;825;0
4;5;900;915;1

this has been imported from another data source but i need to manipulate this value if i can in Access.

In the above record each line represents a different state for a given day and each semicolon separated value represents the following

(enum type,Stateid,Start_time,End_time,Paid or Unpaid)

and i need someway to recognise the integers in each line above because i will be trying to compare start times but also add durations for similar states.

I apologise if i am not expressing my problem accuartely as this is my first post.
Any help would be greatly appreciated.
Jun 5 '07 #1
Share this Question
Share on Google+
6 Replies

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi,

Please forgive my ignorance as i am a newbie on Access .

I have a field on in my table called Sch_Data with the following record .

3;875;646;697;1
3;875;712;770;1
3;53;880;893;1
4;4;697;712;1
4;6;780;825;0
4;5;900;915;1

this has been imported from another data source but i need to manipulate this value if i can in Access.

In the above record each line represents a different state for a given day and each semicolon separated value represents the following

(enum type,Stateid,Start_time,End_time,Paid or Unpaid)

and i need someway to recognise the integers in each line above because i will be trying to compare start times but also add durations for similar states.

I apologise if i am not expressing my problem accuartely as this is my first post.
Any help would be greatly appreciated.
You need to separate this data out into the individual fields.

The only ways to do this are when the data is first imported or using code.
Jun 6 '07 #2

Expert 100+
P: 218
Hint:-

Try the "Split" function...

Steve
Jun 6 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Hint:-

Try the "Split" function...

Steve
I was originally going to suggest it but I don't think m$ are supporting it from 2007 onwards.
Jun 6 '07 #4

Expert 100+
P: 218
Aaww nuts!!! Thort I woz bein clever
Jun 6 '07 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
Aaww nuts!!! Thort I woz bein clever
You were, you just didn't know that M$ were doing their usual "How can I mess up a load of applications when companies upgrade their Office version?"
Jun 6 '07 #6

Expert 100+
P: 218
You were, you just didn't know that M$ were doing their usual "How can I mess up a load of applications when companies upgrade their Office version?"
pas devant les enfants!
Jun 6 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.