Skip to main content

Hello

 

 

When the address field is printed out in excel, it moves to the next line. You can fix this error with existing code.

replace(t.address ,chr(13)|| chr(10),'' ) '' )

 

 

The address field contains ASCII code. Chr (13) || He was doing it with the chr (10) CODE. You can fix this problem with the Replace command.