I export a cell phone log to csv once a month and in the caller-id field it sometimes places a comma between last and first and/initial so the csv thinks they are separate columns.
Extension, CallFrom, CallTime, CallTo...
1234,John Smith,12:05,Sally Smith (valid record)
1234,Smith,John, 12:05 (invalid)
So for example, above, the first record is good. Where the second record is bad. The name John becomes the Call Time value, and the CallTime value becomes CallTo... Etc.
Info: We know there are 13 columns in csv table. And we know the extra commas/field will only occur following the second comma (after CallerId column).
A good row/record will have 12 commas. Whereas a bad row/record will have 13 or 14 (depending if middle initial was used), e.g. Smith, John, P...
So programming logic would be something like...
Count(",") each row
Delete all characters between comma 2 and comma 3
Delete all characters between comma 2 and comma 4
Please ask me any questions. And I am open to any ideas or other solutions.
8 威客就此工作平均出价 $21
hello, you can place your confidence in my Python knowledge and experience. your description looks well thought out, so we'll test if it works as you expect it to. greets, srdjan
hello there fellow, I could do this job in no time, just using some regexes on Python, look my last projects you sure will be glad with the results Rafael Aguilar [login to view URL]
I know python well. I can solve this in less than 2 hours. Ping me if you want to finish this off soon. You can check my python related work here .[login to view URL]
I'll write the program today and send it through a message to you. If you like it you can hire me. I'll be writing it nonetheless and having other people rip you off for a few lines of code isn't nice.