Carriage return

[Kennymc]

In a sql database table there is a column called address.

However if you have more than one line on the address, it's separated by a carriage return within the same column.

when I view the field within the applications I can see the entire address.

In Crystal I only see the first line.

How can I extract all the data in that column? And report each line separately?

ex column address has data trump hotel(CR)room 204
I want to print two columns trump hotel room 204

when I use browse data, I only see trump hotel

suggestions?

 

[pgtek]

Hi

the syntac for carriage return is chr(13)
ex:


will give you
trump hotel (chr(13) room 124

trump hotel
room 124

give us and example of your field content
if the hotelname and room are in one string
ex: trumphotelroom124
or you have 2 table one for hotel and an other for room

what version of crystal and what database

this will help alot. the more you give better the result we can give you

cheer



pgtek