7.122 SUBSTRING

Note: Usage options

The SUBSTRING command is used to copy a string from one field to another field.

The string copied from the first field can be all or only part of the field.

The string can be copied into all or only part of the result field.

Also See

7.122.1 SUBSTRING Parameters

7.122.2 SUBSTRING Examples

                                                         Required

 

  SUBSTRING ---- FIELD -------- field name ---- 1 ----- *END --->

                                             field name field name

                                            (start pos) (length)

 

            >--- INTO_FIELD --- field name ---- 1 ----- *END ---|

                                             field name field name

                                            (start pos) (length)