"Square boxes"

[Guest]

I have a query that seperates the fields by "square boxes". I am pretty sure
that these are from an unknown character, but how can I find out what it is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly, as you can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr
The [] is the "square box symbol". When I copy that symbol into here, it is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

 

[Ken Snell [MVP]]

Post the query's SQL statement. It appears that you are using only half of
what you need to start a new line. In ACCESS, you use the combination of
Chr(13) & Chr(10) for a new line (carriage return and line feed,
respectively).

 

[fredg]

I have a query that seperates the fields by "square boxes". I am pretty sure
that these are from an unknown character, but how can I find out what it is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly, as you can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr
The [] is the "square box symbol". When I copy that symbol into here, it is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

It probably is a carriage return, chr(13).
Because Access requires both the carriage return as well as a line
space to go to the next line ( chr(13) & chr(10) ), it shows the
return as a square.
What do you want to do with it?

Make it into a real Access new line?
Update YourTable Set YourTable.FieldName =
Replace([FieldName],chr(13),chr(13) & chr(10))

Replace it with a space?
Update YourTable Set YourTable.FieldName =
Replace([FieldName],chr(13)," ")

 

[Guest]

Stupid question... How do I show you the SQL Statement?

Post the query's SQL statement. It appears that you are using only half of
what you need to start a new line. In ACCESS, you use the combination of
Chr(13) & Chr(10) for a new line (carriage return and line feed,
respectively).
--

Ken Snell
<MS ACCESS MVP>

I have a query that seperates the fields by "square boxes". I am pretty
sure
that these are from an unknown character, but how can I find out what it
is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly, as you
can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr
The [] is the "square box symbol". When I copy that symbol into here, it
is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

 

[Guest]

Nevermind, found it... This is a simplified version of what I am doing.

Select [Complaint and Witness Forms].ID, [Complaint and Witness
Forms.ComplaintNarrativeOtherNames
From [Complaint and Witness Forms]
Where ((([Complaint and Witness Forms].ID)=[ID])));

Post the query's SQL statement. It appears that you are using only half of
what you need to start a new line. In ACCESS, you use the combination of
Chr(13) & Chr(10) for a new line (carriage return and line feed,
respectively).
--

Ken Snell
<MS ACCESS MVP>

I have a query that seperates the fields by "square boxes". I am pretty
sure
that these are from an unknown character, but how can I find out what it
is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly, as you
can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr
The [] is the "square box symbol". When I copy that symbol into here, it
is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

 

[Guest]

Well, I would like to join two different fields for this reason.

Query returns 8 pieces of information.

1. Name
2. Address
3. City
4. State
5. Zip
6. Phone
7. SSN
8. Date of Birth (DOB)

Each of which are in their own field. So the example I had earlier just
showed the Name information. So the end result would show, if possible.

Name, DOB
Address, City, Zip,
Phone, SSN

In the "array" each entry in the field is seperated by one of the "square
boxes".

If that doesn't work, I just want carraige returns between the names, so
that I can allign the names, Addresses, DOB, etc. It would create a "false"
resolution, but would work for what I am doing.

Thanks for the input!

Blaze

I have a query that seperates the fields by "square boxes". I am pretty sure
that these are from an unknown character, but how can I find out what it is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly, as you can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr
The [] is the "square box symbol". When I copy that symbol into here, it is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

It probably is a carriage return, chr(13).
Because Access requires both the carriage return as well as a line
space to go to the next line ( chr(13) & chr(10) ), it shows the
return as a square.
What do you want to do with it?

Make it into a real Access new line?
Update YourTable Set YourTable.FieldName =
Replace([FieldName],chr(13),chr(13) & chr(10))

Replace it with a space?
Update YourTable Set YourTable.FieldName =
Replace([FieldName],chr(13)," ")

 

[Guest]

I tried the replace method to see if that helped and I still have the "square
boxes". Should I see if it's just the opposite or is there a way to see the
raw ascii code from the data stream?

Blaze

I have a query that seperates the fields by "square boxes". I am pretty sure
that these are from an unknown character, but how can I find out what it is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly, as you can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr
The [] is the "square box symbol". When I copy that symbol into here, it is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

It probably is a carriage return, chr(13).
Because Access requires both the carriage return as well as a line
space to go to the next line ( chr(13) & chr(10) ), it shows the
return as a square.
What do you want to do with it?

Make it into a real Access new line?
Update YourTable Set YourTable.FieldName =
Replace([FieldName],chr(13),chr(13) & chr(10))

Replace it with a space?
Update YourTable Set YourTable.FieldName =
Replace([FieldName],chr(13)," ")

 

[Ken Snell [MVP]]

This query does not show any concatenation being done in the query, so I
must assume that the ComplaintNarrativeOtherNames
field in the Complaint and Witness Forms table/query contains the
concatenated names?

Need to know where the concatenation of the Chr(13) (carriage return)
character is being done, or if the Chr(13) character is already in the data
before the query selects the records.

--

Ken Snell
<MS ACCESS MVP>

Nevermind, found it... This is a simplified version of what I am doing.

Select [Complaint and Witness Forms].ID, [Complaint and Witness
Forms.ComplaintNarrativeOtherNames
From [Complaint and Witness Forms]
Where ((([Complaint and Witness Forms].ID)=[ID])));

Post the query's SQL statement. It appears that you are using only half
of
what you need to start a new line. In ACCESS, you use the combination of
Chr(13) & Chr(10) for a new line (carriage return and line feed,
respectively).
--

Ken Snell
<MS ACCESS MVP>

I have a query that seperates the fields by "square boxes". I am pretty
sure
that these are from an unknown character, but how can I find out what
it
is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly, as you
can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr
The [] is the "square box symbol". When I copy that symbol into here,
it
is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

 

[Guest]

Here's what I am doing source to destination:


1. Infopath used to fill out repeating tables, with merge setup.
1b. Repeating Table has 8 fields as described previously.
2. Infopath submit used to post the data to sharepoint services with merge
on the repeating tables.
3. I use Access to look at the sharepoint site. The data comes in with the
boxes already there. I think it has something to do with the merge field.
4. I use the query to plug the report into something usable as infopath is
near worthless except to enter data with integrity.

Now, I have use the build command to do the following: as Fredg provided:

Replace([FieldName],chr(13),chr(13) & chr(10))

This works to do what I needed. Now is there a way to combine:

Name
Address
City, State, Zip
DOB, SSN

One entry per incoming data stream? If not, I can just put two text boxes
with the data source laid out and it would work, just wouldn't be as "neat"

Thanks for your input on this issue, you've been a real help!

Blaze

This query does not show any concatenation being done in the query, so I
must assume that the ComplaintNarrativeOtherNames
field in the Complaint and Witness Forms table/query contains the
concatenated names?

Need to know where the concatenation of the Chr(13) (carriage return)
character is being done, or if the Chr(13) character is already in the data
before the query selects the records.

--

Ken Snell
<MS ACCESS MVP>

Nevermind, found it... This is a simplified version of what I am doing.

Select [Complaint and Witness Forms].ID, [Complaint and Witness
Forms.ComplaintNarrativeOtherNames
From [Complaint and Witness Forms]
Where ((([Complaint and Witness Forms].ID)=[ID])));

Post the query's SQL statement. It appears that you are using only half
of
what you need to start a new line. In ACCESS, you use the combination of
Chr(13) & Chr(10) for a new line (carriage return and line feed,
respectively).
--

Ken Snell
<MS ACCESS MVP>



I have a query that seperates the fields by "square boxes". I am pretty
sure
that these are from an unknown character, but how can I find out what
it
is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly, as you
can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr
The [] is the "square box symbol". When I copy that symbol into here,
it
is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

 

[fredg]

I tried the replace method to see if that helped and I still have the "square
boxes". Should I see if it's just the opposite or is there a way to see the
raw ascii code from the data stream?

Blaze

I have a query that seperates the fields by "square boxes". I am pretty sure
that these are from an unknown character, but how can I find out what it is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly, as you can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr
The [] is the "square box symbol". When I copy that symbol into here, it is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

It probably is a carriage return, chr(13).
Because Access requires both the carriage return as well as a line
space to go to the next line ( chr(13) & chr(10) ), it shows the
return as a square.
What do you want to do with it?

Make it into a real Access new line?
Update YourTable Set YourTable.FieldName =
Replace([FieldName],chr(13),chr(13) & chr(10))

Replace it with a space?
Update YourTable Set YourTable.FieldName =
Replace([FieldName],chr(13)," ")

You can check the Ascii of that character, or first try
Replace([FieldName],chr(10),"What ever you want here ")

 

[Ken Snell [MVP]]

Do these values appear in separate fields in each record in your incoming
data stream?
Name
Address
City, State, Zip
DOB, SSN

If yes, then you can use a query to concatenate the fields into a single
string and output the result (example shown here is for three fields, with a
blank space separting the value from each field):

SELECT [Field1] & " " & [Field2] & " " [Field3] AS OutputField
FROM TableName;

--

Ken Snell
<MS ACCESS MVP>

Here's what I am doing source to destination:


1. Infopath used to fill out repeating tables, with merge setup.
1b. Repeating Table has 8 fields as described previously.
2. Infopath submit used to post the data to sharepoint services with
merge
on the repeating tables.
3. I use Access to look at the sharepoint site. The data comes in with
the
boxes already there. I think it has something to do with the merge field.
4. I use the query to plug the report into something usable as infopath
is
near worthless except to enter data with integrity.

Now, I have use the build command to do the following: as Fredg provided:

Replace([FieldName],chr(13),chr(13) & chr(10))

This works to do what I needed. Now is there a way to combine:

Name
Address
City, State, Zip
DOB, SSN

One entry per incoming data stream? If not, I can just put two text boxes
with the data source laid out and it would work, just wouldn't be as
"neat"

Thanks for your input on this issue, you've been a real help!

Blaze

This query does not show any concatenation being done in the query, so I
must assume that the ComplaintNarrativeOtherNames
field in the Complaint and Witness Forms table/query contains the
concatenated names?

Need to know where the concatenation of the Chr(13) (carriage return)
character is being done, or if the Chr(13) character is already in the
data
before the query selects the records.

--

Ken Snell
<MS ACCESS MVP>

Nevermind, found it... This is a simplified version of what I am
doing.

Select [Complaint and Witness Forms].ID, [Complaint and Witness
Forms.ComplaintNarrativeOtherNames
From [Complaint and Witness Forms]
Where ((([Complaint and Witness Forms].ID)=[ID])));


:

Post the query's SQL statement. It appears that you are using only
half
of
what you need to start a new line. In ACCESS, you use the combination
of
Chr(13) & Chr(10) for a new line (carriage return and line feed,
respectively).
--

Ken Snell
<MS ACCESS MVP>



I have a query that seperates the fields by "square boxes". I am
pretty
sure
that these are from an unknown character, but how can I find out
what
it
is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly, as
you
can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson
Jr
The [] is the "square box symbol". When I copy that symbol into
here,
it
is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

 

[Guest]

They are in different fields. I'm using the chr(10) & chr(13) command to
seperate the CR's. Can I still do this?

Thanks!

Blaze

Do these values appear in separate fields in each record in your incoming
data stream?
Name
Address
City, State, Zip
DOB, SSN

If yes, then you can use a query to concatenate the fields into a single
string and output the result (example shown here is for three fields, with a
blank space separting the value from each field):

SELECT [Field1] & " " & [Field2] & " " [Field3] AS OutputField
FROM TableName;

--

Ken Snell
<MS ACCESS MVP>

Here's what I am doing source to destination:


1. Infopath used to fill out repeating tables, with merge setup.
1b. Repeating Table has 8 fields as described previously.
2. Infopath submit used to post the data to sharepoint services with
merge
on the repeating tables.
3. I use Access to look at the sharepoint site. The data comes in with
the
boxes already there. I think it has something to do with the merge field.
4. I use the query to plug the report into something usable as infopath
is
near worthless except to enter data with integrity.

Now, I have use the build command to do the following: as Fredg provided:

Replace([FieldName],chr(13),chr(13) & chr(10))

This works to do what I needed. Now is there a way to combine:

Name
Address
City, State, Zip
DOB, SSN

One entry per incoming data stream? If not, I can just put two text boxes
with the data source laid out and it would work, just wouldn't be as
"neat"

Thanks for your input on this issue, you've been a real help!

Blaze

This query does not show any concatenation being done in the query, so I
must assume that the ComplaintNarrativeOtherNames
field in the Complaint and Witness Forms table/query contains the
concatenated names?

Need to know where the concatenation of the Chr(13) (carriage return)
character is being done, or if the Chr(13) character is already in the
data
before the query selects the records.

--

Ken Snell
<MS ACCESS MVP>

Nevermind, found it... This is a simplified version of what I am
doing.

Select [Complaint and Witness Forms].ID, [Complaint and Witness
Forms.ComplaintNarrativeOtherNames
From [Complaint and Witness Forms]
Where ((([Complaint and Witness Forms].ID)=[ID])));


:

Post the query's SQL statement. It appears that you are using only
half
of
what you need to start a new line. In ACCESS, you use the combination
of
Chr(13) & Chr(10) for a new line (carriage return and line feed,
respectively).
--

Ken Snell
<MS ACCESS MVP>



I have a query that seperates the fields by "square boxes". I am
pretty
sure
that these are from an unknown character, but how can I find out
what
it
is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly, as
you
can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson
Jr
The [] is the "square box symbol". When I copy that symbol into
here,
it
is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

 

[Guest]

Works with the chr(10).

Thank you for the great advise, I was somewhat lost!

Blaze

I tried the replace method to see if that helped and I still have the "square
boxes". Should I see if it's just the opposite or is there a way to see the
raw ascii code from the data stream?

Blaze

On Fri, 5 Aug 2005 12:29:03 -0700, Blaze wrote:

I have a query that seperates the fields by "square boxes". I am pretty sure
that these are from an unknown character, but how can I find out what it is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly, as you can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr
The [] is the "square box symbol". When I copy that symbol into here, it is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

It probably is a carriage return, chr(13).
Because Access requires both the carriage return as well as a line
space to go to the next line ( chr(13) & chr(10) ), it shows the
return as a square.
What do you want to do with it?

Make it into a real Access new line?
Update YourTable Set YourTable.FieldName =
Replace([FieldName],chr(13),chr(13) & chr(10))

Replace it with a space?
Update YourTable Set YourTable.FieldName =
Replace([FieldName],chr(13)," ")

You can check the Ascii of that character, or first try
Replace([FieldName],chr(10),"What ever you want here ")

 

[Ken Snell [MVP]]

If you can post details about the table's structure, and the fields' actual
contents (examples would be good), I'm sure we can give you a more specific
query to do what you seek. Otherwise, the generic query I suggested earlier
is as much as I can provide at this moment.

--

Ken Snell
<MS ACCESS MVP>

They are in different fields. I'm using the chr(10) & chr(13) command to
seperate the CR's. Can I still do this?

Thanks!

Blaze

Do these values appear in separate fields in each record in your incoming
data stream?
Name
Address
City, State, Zip
DOB, SSN

If yes, then you can use a query to concatenate the fields into a single
string and output the result (example shown here is for three fields,
with a
blank space separting the value from each field):

SELECT [Field1] & " " & [Field2] & " " [Field3] AS OutputField
FROM TableName;

--

Ken Snell
<MS ACCESS MVP>

Here's what I am doing source to destination:


1. Infopath used to fill out repeating tables, with merge setup.
1b. Repeating Table has 8 fields as described previously.
2. Infopath submit used to post the data to sharepoint services with
merge
on the repeating tables.
3. I use Access to look at the sharepoint site. The data comes in
with
the
boxes already there. I think it has something to do with the merge
field.
4. I use the query to plug the report into something usable as
infopath
is
near worthless except to enter data with integrity.

Now, I have use the build command to do the following: as Fredg
provided:

Replace([FieldName],chr(13),chr(13) & chr(10))

This works to do what I needed. Now is there a way to combine:

Name
Address
City, State, Zip
DOB, SSN

One entry per incoming data stream? If not, I can just put two text
boxes
with the data source laid out and it would work, just wouldn't be as
"neat"

Thanks for your input on this issue, you've been a real help!

Blaze


:

This query does not show any concatenation being done in the query, so
I
must assume that the ComplaintNarrativeOtherNames
field in the Complaint and Witness Forms table/query contains the
concatenated names?

Need to know where the concatenation of the Chr(13) (carriage return)
character is being done, or if the Chr(13) character is already in the
data
before the query selects the records.

--

Ken Snell
<MS ACCESS MVP>

Nevermind, found it... This is a simplified version of what I am
doing.

Select [Complaint and Witness Forms].ID, [Complaint and Witness
Forms.ComplaintNarrativeOtherNames
From [Complaint and Witness Forms]
Where ((([Complaint and Witness Forms].ID)=[ID])));


:

Post the query's SQL statement. It appears that you are using only
half
of
what you need to start a new line. In ACCESS, you use the
combination
of
Chr(13) & Chr(10) for a new line (carriage return and line feed,
respectively).
--

Ken Snell
<MS ACCESS MVP>



I have a query that seperates the fields by "square boxes". I am
pretty
sure
that these are from an unknown character, but how can I find out
what
it
is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly,
as
you
can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W
Henderson
Jr
The [] is the "square box symbol". When I copy that symbol into
here,
it
is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze