Transforming Data

This page is currently incomplete, but you can find information about this topic at the links below:

- change -- The change statement replaces text with new text in the current field (selected records only).
- changeword -- The changeword statement replaces one word with another in the current field (selected records only).
- changewordexact -- The changewordexact statement replaces one word with another in the current field (selected records only).
- emptyfill -- The emptyfill statement fills every empty visible cell in the active field with the specified value.
- fill -- The fill statement fills every visible cell in the active field with the specified value.
- fillall -- The fillall statement modifies the operation of the following fill statement so that all records are modified, not just visible records.
- formulafill -- The formulafill statement fills every visible cell in the active field with the result of the specified formula.
- formulafillallfields -- The formulafillallfields statement fills every visible cell in all fields with the result of the specified formula.
- outlinelevel -- The outlinelevel statement expands or collapses the entire database to show a specific level of data or summary level.
- propagate -- The propagate statement fills all the empty cells in the current field. Each empty cell is filled with the value of the first non-empty cell above it.
- propagateup -- The propagateup statement fills all the empty cells in the current field. Each empty cell is filled with the value of the first non-empty cell below it.
- runningdifference -- The runningdifference statement calculates the running difference for the current field.
- runningtotal -- The runningtotal statement calculates the running total for the current field.
- sequence -- The sequence statement fills every visible cell in the current field with a numeric sequence.
- slidedata -- The slidedata statement slides the columns at and to the right of the current column.
- speedcopy -- The speedcopy statement copies multiple adjacent fields from a record in one database to a record in another.
- summarylevel -- The summarylevel statement changes the summary level of the current line.
- unpropagate -- The unpropagate statement removes repeating data from the currently selected field. If several records in a row contain the same data, this statement erases all but the first (top) value.
- unpropagateup -- The unpropagateup statement removes repeating data from the currently selected field. If several records in a row contain the same data, this statement erases all but the last (bottom) value.

History

Version | Status | Notes
10.0 | Updated | Carried over from Panorama 6.0, with some updates.