Find Jobs
Hire Freelancers

6441 dedupe columns script

N/A

Selesai
Disiarkan lebih dari 17 tahun yang lalu

N/A

Dibayar semasa penghantaran
I need this script to be modified (or a new script created) so that the program will dedupe records from a several fields in each of two different source files. The format that you need to read needs to include both CSV and | for field delimiters. Ignore spaces after or before the delimiter (these are all the same: ", field" ",field " ",field"). It's ok that some of the records do not have the same number of fields. Example: [login to view URL]: field1,field2,"field, 3", field4 field1_a,field2_a,"field, 3_a", field4_a field1_b,field2_b,"field, 3_b", field4_b field1_c,field2_c,"field, 3_c", field4_c [login to view URL]: field1|field2|"field, 3"|field4 field1_a|field2_a|"field3_a"| field4_a field1_b|"field2_b"|"field3_b" field1_c|field2_XXX|"field3_c"| field4_c Running the program, I would select these two input files (one as the existing source file, and one as the new source file). I need to select the fields that I am using as fields to look for matching duplicates. In this example, I will choose fields 1 and 2. If fields 1 and 2 are the same in both files (ignore the "'s), then I will not output that record in the output file. In this example, the output would be: field1_c|field2_XXX|"field3_c"| field4_c because this is the only record that does not have the same fields for both field1 and field2 in both input files. You are only outputting the non-matching records from the NEW source file. ---- If you use the attached script, then you will need to make it work with standard CSV files (i.e. where the quotes are not necessary for escaping). This script will need to be adjusted to make that work.
ID Projek: 1757312

Tentang projek

1 cadangan
Projek jarak jauh
Aktif 12 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
please check pmb
$50 USD dalam 1 hari
4.9 (719 ulasan)
8.2
8.2

Tentang klien

Bendera UNITED STATES
Austin, United States
4.9
57
Kaedah pembayaran disahkan
Ahli sejak Mei 18, 2007

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.