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

Split a field into multiple fields using space as delim

P: n/a
Hi - and thanks for reading this.
I'm setting up a scheduled routine which links to an existing file.
It's bringing in one field which has at least 2 and maybe 10 'words',
separated by spaces, which I'd like to split into separate fields.
So:
ALTAI RPS 21 CX HPH
would become
ALTAI in a new field, RPS in the next new field etc.
At the moment, I'm wrestling with a query with instr functions all
over the place. If anyone has seen/used a routine to simplify this,
I'd be very grateful!
Cheers.
Andy.

Oct 18 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
See the ParseWord() function here:
http://allenbrowne.com/func-10.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<an*********@gmail.comwrote in message
news:11**********************@v29g2000prd.googlegr oups.com...
Hi - and thanks for reading this.
I'm setting up a scheduled routine which links to an existing file.
It's bringing in one field which has at least 2 and maybe 10 'words',
separated by spaces, which I'd like to split into separate fields.
So:
ALTAI RPS 21 CX HPH
would become
ALTAI in a new field, RPS in the next new field etc.
At the moment, I'm wrestling with a query with instr functions all
over the place. If anyone has seen/used a routine to simplify this,
I'd be very grateful!
Cheers.
Andy.
Oct 18 '07 #2

P: n/a
Fantastic!! Thanks very much. A bit of tweaking and it works
beautifully!

Andy.
On Oct 18, 12:41 pm, "Allen Browne" <AllenBro...@SeeSig.Invalid>
wrote:
See the ParseWord() function here:
http://allenbrowne.com/func-10.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<andy.bay...@gmail.comwrote in message

news:11**********************@v29g2000prd.googlegr oups.com...
Hi - and thanks for reading this.
I'm setting up a scheduled routine which links to an existing file.
It's bringing in one field which has at least 2 and maybe 10 'words',
separated by spaces, which I'd like to split into separate fields.
So:
ALTAI RPS 21 CX HPH
would become
ALTAI in a new field, RPS in the next new field etc.
At the moment, I'm wrestling with a query with instr functions all
over the place. If anyone has seen/used a routine to simplify this,
I'd be very grateful!
Cheers.
Andy.- Hide quoted text -

- Show quoted text -

Oct 18 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.