concatenation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im joining multiple names and addresses in a query to single number groups
using (Field2: Conc("Field2","Node4_ID",[Node4_ID],"OCR")), which groups them
with a comma. When I put the groups on a document I can't get the names to
unlink. for instance, starting each sentenance with a name. I keep getting
the whole group with commas between the name;
name, address, name address, name address
instead of;
name, address
name, address
name, address
How do I fix this? do I need to remove the commas between name groups? and
how?
 
Where in between?

KARL DEWEY said:
Include this between them --
Chr(13) & Chr(10)

CZ said:
Im joining multiple names and addresses in a query to single number groups
using (Field2: Conc("Field2","Node4_ID",[Node4_ID],"OCR")), which groups them
with a comma. When I put the groups on a document I can't get the names to
unlink. for instance, starting each sentenance with a name. I keep getting
the whole group with commas between the name;
name, address, name address, name address
instead of;
name, address
name, address
name, address
How do I fix this? do I need to remove the commas between name groups? and
how?
Click to expand...
Click to expand...
 
I did not read you post closely. It appears that your are using a module to
perform a concatenation function named "conc" on the data. You need to make
a copy of the module named conc1 and edit it to replace the second comma with
Chr(13) & Chr(10).

CZ said:
Where in between?

KARL DEWEY said:
Include this between them --
Chr(13) & Chr(10)

CZ said:
Im joining multiple names and addresses in a query to single number groups
using (Field2: Conc("Field2","Node4_ID",[Node4_ID],"OCR")), which groups them
with a comma. When I put the groups on a document I can't get the names to
unlink. for instance, starting each sentenance with a name. I keep getting
the whole group with commas between the name;
name, address, name address, name address
instead of;
name, address
name, address
name, address
How do I fix this? do I need to remove the commas between name groups? and
how?
Click to expand...
Click to expand...
Click to expand...
 
The module is called Field2, I first built a field that joined the name
address, title, phone, and e-mail. that was called field2 in the first query,
with the query name of OCR. In the OCR query there is an ID, Number, Field2,
OCR, and the expr1 from that query. I now want to combine the names that
belong to each ID in a gruop and be able to add that to a report with the
names seperated as I indicated earlier, ie. without commas. Maybe I used the
wrong command and need to see if there is another way? the Chr(13) & Chr(10).
is not being accepted in the command.



KARL DEWEY said:
I did not read you post closely. It appears that your are using a module to
perform a concatenation function named "conc" on the data. You need to make
a copy of the module named conc1 and edit it to replace the second comma with
Chr(13) & Chr(10).

CZ said:
Where in between?

KARL DEWEY said:
Include this between them --
Chr(13) & Chr(10)

:

Im joining multiple names and addresses in a query to single number groups
using (Field2: Conc("Field2","Node4_ID",[Node4_ID],"OCR")), which groups them
with a comma. When I put the groups on a document I can't get the names to
unlink. for instance, starting each sentenance with a name. I keep getting
the whole group with commas between the name;
name, address, name address, name address
instead of;
name, address
name, address
name, address
How do I fix this? do I need to remove the commas between name groups? and
how?
Click to expand...
Click to expand...
Click to expand...
 
Sorry, I can not help more.

CZ said:
The module is called Field2, I first built a field that joined the name
address, title, phone, and e-mail. that was called field2 in the first query,
with the query name of OCR. In the OCR query there is an ID, Number, Field2,
OCR, and the expr1 from that query. I now want to combine the names that
belong to each ID in a gruop and be able to add that to a report with the
names seperated as I indicated earlier, ie. without commas. Maybe I used the
wrong command and need to see if there is another way? the Chr(13) & Chr(10).
is not being accepted in the command.



KARL DEWEY said:
I did not read you post closely. It appears that your are using a module to
perform a concatenation function named "conc" on the data. You need to make
a copy of the module named conc1 and edit it to replace the second comma with
Chr(13) & Chr(10).

CZ said:
Where in between?

:

Include this between them --
Chr(13) & Chr(10)

:

Im joining multiple names and addresses in a query to single number groups
using (Field2: Conc("Field2","Node4_ID",[Node4_ID],"OCR")), which groups them
with a comma. When I put the groups on a document I can't get the names to
unlink. for instance, starting each sentenance with a name. I keep getting
the whole group with commas between the name;
name, address, name address, name address
instead of;
name, address
name, address
name, address
How do I fix this? do I need to remove the commas between name groups? and
how?
Click to expand...
Click to expand...
Click to expand...
 
CZ,
It sounds like you're trying to do something similar to what I need to do,
however, I have been using EXCEL as an intermediary step to get name, address
and phone #'s from a neighborhood directory into a database record. I can
scan the original page,use the OCR to convert to text, and then import into
EXCEL just fine. The problem is that an original record that looks like a
mailing label is still in that form in cells A1, B1, C1, D1 etc. To create a
data record I need each field of the name & address to be in cells A1, A2,
A3, etc. Additionally B1 contains both the street address and the phone
number in the original format. This causes the additional problem of trying
to parse the lines into the appropriate cells when moving to one line. This
is much more work than is worth while. Is there another way you can suggest
to get this done? I have ACCESS but have not used it in years. Is there a
better way with that?
 
Back
Top