Knowledgebase: Reports and Letters > Writeback
Edit Field to Clean It Up
Posted by Linda on 12 February 2008 05:38 PM
This simple code will work to clean up a field. This is sometimes necessary if you find that importing has accidentally written hidden characters to a field, such as a newline character.

This example writes back to the Debtor Address field.

First, tag all debtors that you want to clean up. Then print this report to ALL.

@varAddress* = ""
@varBlank* = ""
@varAddress = @de.ad
@SETde.ad = @varBlank
@EDITde.ad = @varAddress

The address is stored in a variable. Then the address field is blanked out with the @SET command and rewritten with the @EDIT command. This writes back only valid characters and cleans up any hidden newline characters.
(0 vote(s))
Helpful
Not helpful

Comments (0)