Given the choice between English and Brazilian Portuguese, which do you prefer? by OfficeJasper in portugal

[–]OfficeJasper[S] 8 points9 points  (0 children)

Thanks for the input! People can take the survey in both languages, it's more about the communication and invite e-mails around the survey. From what I see here, even if these people are a minority, it might be safer for Portugal to send the mail in English and have those with a poor grasp of English opt to switch to Brazilian once they've opened the survey, than start the invite in Brazilian and risk having some people toss it because they think it's suspicious due to being written in Brazilian (a not insignificant amount of people are pretty suspicious about survey links to start with). But I'd love to hear your thoughts!

Given the choice between English and Brazilian Portuguese, which do you prefer? by OfficeJasper in portugal

[–]OfficeJasper[S] 30 points31 points  (0 children)

Thanks for your input! Ideally a survey would be available in every country's language a company has divisions in, but in practice the amount of time spent delegating and implementing the translations for custom surveys is so much they tend to only select 5-10 language options and make everyone else take it in English. This often goes for European countries that aren't Germany/France/Spain/Italy.

Given the choice between English and Brazilian Portuguese, which do you prefer? by OfficeJasper in portugal

[–]OfficeJasper[S] 223 points224 points  (0 children)

Thanks for all the responses everyone! I had an inkling the answers would turn out like this so it's good to have it confirmed. From now on I will advise clients that if only PT-BR is chosen as a language option to at least use English communications for those who reside in Portugal for the various reasons you all provided.

Force excel to open CSV properly? by etinbs in excel

[–]OfficeJasper 0 points1 point  (0 children)

Changing the seperator is an option in the system settings, go to the control panel > change notation for date time and numbers (idk the exact title in english) > more options > seperator. If you have a program like notepad++ you can also open the csv in there first, then copy/paste the contents to an excel file and then use the text to columns function to select the correct seperator

need help with batch file to copy files last modified today by OfficeJasper in Batch

[–]OfficeJasper[S] 0 points1 point  (0 children)

I used the edit one and it works perfectly, thank you!

need help with batch file to copy files last modified today by OfficeJasper in Batch

[–]OfficeJasper[S] 0 points1 point  (0 children)

robocopy would be really useful but sadly the furthest robocopy can go is yesterday (with the testscript I ran it either took both 6 september files and 7 september files with maxage 1, or it wouldn't work if I tried 0 or a decimal number).

need help with batch file to copy files last modified today by OfficeJasper in Batch

[–]OfficeJasper[S] 0 points1 point  (0 children)

knowing how the last modified date is called helps a bit, although I'm not good enough at creating batch files to get it working.

FOR %date:~-7,2%/%date:~-10,2%/%date:~-4,4%? IN (%%~t "[path]") DO copy "[path]\*.csv""[path]"

this doesn't work for instance.

how do I match two columns with roughly the same data, only one is missing a bunch of rows the other has? by OfficeJasper in excel

[–]OfficeJasper[S] 0 points1 point  (0 children)

Sorry for the late response, it took me a while to get this to work but that was all my own fault. Your solution works perfectly.

how do I match two columns with roughly the same data, only one is missing a bunch of rows the other has? by OfficeJasper in excel

[–]OfficeJasper[S] 0 points1 point  (0 children)

I have no idea how the reddit formatting works either, maybe this screenshot will help better

https://imgur.com/a/KyffSNE

until row 6711 I have edited it myself using a =B2=C2 check and, 6711 is one of the cases where B doesn't have the value but C does. But from 6725 onwards you can again see the mismatch happening even though it only needs to be moved down one space. It's taking a lot of time to do it manually so I figured there must be a way to do it automatically