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.
2  12500 
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.
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 -
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: uc_sk |
last post by:
Hello All
I am a newbie to PERL language...If i have a file with data of form
abcd 4 {1,2,3} 3
lmn- 3 {12,18,19,22} 4
then i can read them as...
($list $listTotal $set $noElements) = split /...
|
by: |
last post by:
Hello everyone! :-D
OK, I've came across many functions for this, but none works! I need one
that works like this:
StringSplit(string str, string delim, vector<string> results)
Either with...
|
by: andrewcw |
last post by:
The split function takes as a parameter what I understand
as array of Char.
I can define the delimiter like this:
string innerText = new string;
char chSplit={'='};...
|
by: William Stacey [MVP] |
last post by:
Would like help with a (I think) a common regex split example. Thanks for
your example in advance. Cheers!
Source Data Example:
one "two three" four
Optional, but would also like to...
|
by: David Logan |
last post by:
We need an additional function in the String class. We need the ability
to suppress empty fields, so that we can more effectively parse. Right
now, multiple whitespace characters create multiple...
|
by: MrHelpMe |
last post by:
Hello again experts,
I have successfully pulled data from an LDAP server and now what I want
to do is drop the data into a database table. The following is my code
that will insert the data but...
|
by: vang |
last post by:
How do I find out which delimiter if found/used when splitting a
string with multiple delimiters are defined in a char array?
Example:
dim i as integer
dim returnText as string
dim InputText...
|
by: kaplan.gillian |
last post by:
Hi everyone,
I currently have an Access database that includes quite a few
long memo fields. When I create a report of my data, Access
does not allow the memo fields to be split with the page...
|
by: H |
last post by:
Hi,
I have the following address fields in a table:
flat_number
house_name_or_number
street
village
postal_town
county
postcode
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
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,...
| |
