Here are two example cvs files. The hard part is match data could be in any column.

csv1:

3.0.425146689842197.html,https://www.yelp.com/c/seattle/oncologist,"ht +tps://www.yelp.com/c/seattle/oncologist, Yelp,recommendation,San Fran +cisco, bay area, local,business,review,friend,restaurant,dentist,doct +or,salon,spa,shopping,store,share,community,massage,sushi,pizza,nails +,New York,Los Angeles",,"The Best 10 Oncologist in Seattle, WA - Last + Updated January 2018 - Yelp",,"Best Oncologist in Seattle, WA - Dr. +Toy Story, Seattle Integrative Oncology, Cancer Treatment Navigator, +Sherry Hu, MD, PhD, Wong Matthew L, MD, Pacific Northwest Integrative + Medicine, Michael A Hunter, MD, Rapha Integrative Family Clinic,_&#1 +32;_",,Dr. Hunter is an amazingly empathetic and incredibly,, Hunter +is an amazingly empathetic and incredibly,Dr. Chang is knowledgeable +&amp; gentle. She's a mother,, Chang is knowledgeable &amp; gentle. S +he's a mother 3.0.525511480497915.html,https://www.yelp.com/c/portland/health,"https +://www.yelp.com/c/portland/health, Yelp,recommendation,San Francisco, + bay area, local,business,review,friend,restaurant,dentist,doctor,sal +on,spa,shopping,store,share,community,massage,sushi,pizza,nails,New Y +ork,Los Angeles",,Health & Medical in Portland - Yelp,,"The Best Heal +th & Medical in Portland on Yelp. Read about places like: Precision H +ealing, Mudra Massage, Therapydia Portland, Skin by Lovely Portland, +Farma, Eyes On Broadway, Laurelwood Dental, Myoptic Optometry + Moder +n Eyewear...",,Dr. Barreto</span> was a,, Barreto</span> was a,Dr.Phi +llips for a couple years now and she is simply,,Phillips for a couple + years now and she is simply 3.0.744123631398576.html,https://www.providence.org/doctors/profile.as +px?name=miklos++simon&id=157134,"https://www.providence.org/doctors/p +rofile.aspx?name=miklos++simon&id=157134, HematologyMedical Oncology, + Miklos Simon, MD, Portland,OR",,"Miklos Simon, MD | Portland,OR, ",, +"Miklos Simon, MD is a specialist in HematologyMedical Oncology who h +as an office at 5050 Northeast Hoyt Street in Portland, OR and can be + reached at 503-239-7767.",,Dr. Simon's practice is focused in the fi +eld of,, Simon's practice is focused in the field of,"Dr. Simon was b +orn in Budapest, Hungary.",," Simon was born in Budapest, Hungary."

csv2

Dr. Toy Story,"Clinical Data Manager, Statistical Center - Fred Hutch +","Cancer Care Alliance,; Centre for Addiction and Mental Health Tran +slational Addiction Research Laboratory,; SKMTranscription and ProScr +ipt Medical ... Obtaining, abstracting, coding and recording complex +data into databases, study-specific electronic and paper-based data- +capture systems..." Leon Smith MD,"Executive Medical Director, Clinical Lead, Research and + Development - Seattle Genetics"," medical oncologist, joins Genetics + with a vast experience in Medical Affairs, R&D and in the Tech Indus +try. In his role, Global Medical ... Project DataSphere is a universa +l platform to responsibility share datasets to revolutionalize cancer + research. It is designed to..." Dr. Donna Lapmaker,not provided," medical oncologist, joins Genetics w +ith a vast experience in Medical Affairs, R&D and in the Tech Industr +y. In his role, Global Medical ... Project DataSphere is a universal +platform to responsibility share datasets to revolutionalize cancer r +esearch. It is designed to..."

In reply to Re^2: compare 2 CSV files for string return lines in both if match by Anonymous Monk
in thread compare 2 CSV files for string return lines in both if match by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.