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
$ ps PID TTY TIME CMD 18315 pts/3 00:00:00 bash 18347 pts/3 00:00:00 psTIME:
$ cat file Unix,10,A Linux,30,B Solaris,40,C HPUX,20,D Ubuntu,50,E