I'm comparing two csv's with BC4's built-in csv formats. I have mostly numeric data, and I definitely want the table view, but my first column has values like "user1_name_processed_2016-9-22_upside_down". I'd like to match cells in different files for this column if the "user1_name" portion is the same, but ignore the date and everything thereafter (or better, just the date). I don't see a way to define a grammar for cells in a table compare. Any other ideas that would keep me in the table view?
I've loved BC for 10+ years, btw. Keep going, you guys!
I've loved BC for 10+ years, btw. Keep going, you guys!
Comment