csv - Finding Duplicates (Regex) -

I have a CSV list of 500 members with whose phone numbers. I tried diff tools but could not find any duplicates

Can I use regex to find duplicate rows by the members' phone numbers?

I'm using Textet on Mac.

Many thanks

What duplicates are you looking for? Full line or just one phone number?

If this is the full line, then try it:

  sort phonelist.txt | UNIK-C | Sort - n  

and you will see all the lines below, which are more than once.

If this is just a phone number in some columns, then use it:

  awk -F ';' '{Print $ 4}' phonelist.txt | | UNIK-C | Sort -n  

Replace '4' with the number of columns with the phone number and ';'

Or give us some example lines from the file.

Edit :

If the data format is: name, mobile, phone, unique, group , then using the following Do:

  awk -F ',' '{print $ 3}' Phonelist.txt | UNIK-C | Sort -n  

in the command line.