DBImport - Calculations

In the field you can define a list of required modifications of imported values. Each row represents one edit for the defined field. One field can be specified multiple times, then the adjustments are made in the specified order.

Single Line Syntax

Supported Calculation Names

• Trim - remove spaces at the beginning and end, i.e. Name=Trim()
• Clean(Type) - remove unprintable and possibly special characters, Type specifies the removal range
  - without parameter = only unprintable characters are removed
  - parameter = Spec - special characters are also removed
  - parameter = Local - local characters are also removed
  - parameter = All - also special and local characters are removed (only numbers and letters a..z remain)
    e.g., Name=Clean(), Name=Clean(Spec)   
• RemoveChar(list) - remove defined characters, which can be defined directly or using a numeric code beginning with #
    e.g. Title=RemoveChar(?!, # 9, # 105)
• Left(Len) - use only a defined number of characters from the beginning, eg LastName = Left (20)
• Right(Len) - Use only a defined number of characters from the end, eg Title = Right (4)
• Middle(Start, Len) - use only a defined number of characters from a defined position, such as TelNumber = Middle (4.9)
• Part(Separator, PartIndex) - use only the xth part according to the specified separator, eg use only the text to the first space LastName = Part (, 1) < / li>
• FromTo(From, To) - use only the part from the defined beginning and end, eg Domain = FromTo (@ ,.)
• Replace(original, new) - replace the original text with a new one, such as URL = Replace (/, \)