I have data which looks like the following:
[000003074859, 000003075752, 000003224575, 000003228286, 000003235217, 000003246379, 000003246434, 000003246725, 000003246934, 000003248574]
[0010242946, 0002363081, 000006459131, 0010275565, 000000430019, 000000465470, 000000465546, 000003228900, 000003616661, 000003648249]
I would like to:
1) Remove the brackets and commas
2) Change the CSV into one row per entry
3) dedup
So, the final data would look like:
000003074859
000003075752
000003224575
....................
Thank you very much in advance
... View more