Tip: Address field display problem in Excel

  • 4 January 2021
  • 0 replies
  • 32 views

Userlevel 5
Badge +8

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.

 


This topic has been closed for comments