Let us consider a file with the following content. The duplicate record is 'Linux' with 2 entries :
$ cat file Unix Linux Solaris AIX Linux
$ cat file Unix Linux Solaris AIX Linux
$ cat file Unix Linux Solaris AIX Ubuntu Unix
$ cat file 20 30 21 33 33 32 12 21 12
substr(STRING, OFFSET, LENGTH, REPLACEMENT)where STRING - the actual string from which the substring is to be extracted