Substrings

substring extract problem

hi .... i have a text like this .... ======== 1079.tif Image Description               : Vexcel-UCD-Level-3..------------------..CAM_ID:                  UCD-SU-1-0018 [5]..RECORD_GUID:            ...

CUT SUBSTRINGS USING SYNCSORT

HPW IS ONE ABLE TO CUT A SUBSTRING FROM THE NAME OF A FILE AND ALSO APPEND IT AS A RECORD IN THE DATABASE??