:wave::skin-tone-3: Is there anyone here who is go...
# tribec
calm-grass-85557
02/15/2019, 12:13 PM👋🏼 Is there anyone here who is good with google sheets ?? I need some specific help with cleaning out dirty data ( using different formula and moving/combining rows of data )
calm-grass-85557
02/15/2019, 12:19 PMTrying to combine data from 2 rows into 1 ( and similarly for other 50 rows) and also do better regex matches than
Copy code
=OR(REGEXMATCH(TO_TEXT(R2), ".*US.*"), REGEXMATCH(TO_TEXT(R2), ".*401.*"), REGEXMATCH(TO_TEXT(R2), ".*EU.*"))t
tall-postman-9284
02/15/2019, 4:18 PMDownload, uae csvkit on it and reupload?
👀 1
c
calm-grass-85557
02/18/2019, 6:01 AMThank you Phani for that tip !! NoCode philosophy has blinded me a lot 🤦🏼♂️
calm-grass-85557
02/18/2019, 6:02 AMCoding is a superpower 😊 and it's better to use it rather than learn advanced formulas on Google sheet
t
tall-postman-9284
02/18/2019, 6:24 AMYou don't need to code, really. Just shell commands you explore with. Csvkit has lots of nice helpers.
c
calm-grass-85557
02/18/2019, 7:56 AMCSVkit is quite powerful !! But for this case, code makes more sense.