FormatForExport

Use this event to reformat the content of a field, for example to unify a date or amount format or to remove prefixes and suffixes.

Formatting information can be kept within pField.FormattedText rather than pField.Text. In this way, the original pField.Text is used for learning within the Scripting Guide engines. The formatted pField.FormattedText can be used via scripting for export.

Syntax

[FieldName]_FormatForExport (pField as ISCBCdrField)

Parameter	Description
pField	Current field.

Sample Code

Private Sub Amount_FormatForExport(pField as SCBCdrField)
   Dim NewAmount as string
   If MyReformatAmount(pField, NewAmount) = TRUE then
      'reformatting is successful to generate a unified output format for the fields' content.
      'Use the pField.FormattedText to save the reformatted information. Then use pField.FormattedText also for the Export, instead of pField.Text
      pField.FormattedText = NewAmount
   End if
End Sub