Hello, need some help. I have to do reconciliation of purchase file and 2A gst file. So basically matching which all invoice numbers from purchase file are there in 2A file. I know looks simple, but the challenge is that the format in which the invoice numbers are written in purchase files are different eg invoice in 2A is 12345 in purchase file it would be written as 1234-5 or INV-12345 or INV/12345 or 2020_12345 or 2020/12345 or 2020/Inv12345 or 2020/inv_12345 so on and so forth. There are many such combinations in whihc this is written. Need help in how shall I match to get maximum matches. Thank you for any help in advance. Doing this in R, using the latest version.
Your videos are great! Always looking forward to your tutorials.
This is awesome! Thank you very much for the clear explanation! Regards from Argentina
microphone made me sound like a squirrel lol
The audio is lagging a little bit! Great content though
Hello, can you help with writing data from R studio to SQL server using ODBC, thank you.
Hello, need some help. I have to do reconciliation of purchase file and 2A gst file. So basically matching which all invoice numbers from purchase file are there in 2A file. I know looks simple, but the challenge is that the format in which the invoice numbers are written in purchase files are different eg invoice in 2A is 12345 in purchase file it would be written as 1234-5 or INV-12345 or INV/12345 or 2020_12345 or 2020/12345 or 2020/Inv12345 or 2020/inv_12345 so on and so forth. There are many such combinations in whihc this is written. Need help in how shall I match to get maximum matches. Thank you for any help in advance. Doing this in R, using the latest version.
I am not very sure but I think in package 'dplyr', function 'group_by' will help you sort the problem.
video is lagging.. could you please re-upload this video?
this is not R studio.