Link to home
Start Free TrialLog in
Avatar of rustyroo
rustyrooFlag for Australia

asked on

need part of field in access only

Hey an easy one for anyone but me probably... need to separate this data from one field into 3

eg:

10:business name:$3.21
10         business name           $3.21

so i want one with 10, one with "business name" and one with $3.21

what would be the easiest way to do this, either using a modify query or vba macro?

appreciate the help.

Rusyt
Avatar of Kent Dyer
Kent Dyer
Flag of United States of America image

Look into the use of SPLIT on the ":" and that should do the trick for you.

HTH,

Kent
ASKER CERTIFIED SOLUTION
Avatar of duttcom
duttcom
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rustyroo

ASKER

Thanks... it is one field of about 20 that i have to import.  The rest are easy.  My plan is to import the 20 fields to one table, then append this to another new table with the extra 3 columns which will be the main data table I use.  I will have to do this monthly, so plan to use this first table as a temp table on the way to appending.  
Hope that helps
Where are you importing from? Is it a text file or some other source?

You may be able to split that field on import depending on the source.
it is a csv file
As duttcom mentioned, you can parse this right when you import.  Just specify the colon ":" as your delimeter.