After Rain by Pixel Jeff #pixelart

@tinker

awk -F',' 'NR==FNR{a[$1]=$2; next} {print $0","a[$2]}' file2.csv file1.csv

@tinker

-F',' specifies the field separator as a comma

NR==FNR{a[$1]=$2; next} reads the first file (file2.csv) and stores its second field in an array a indexed by the first field

{print $0","a[$2]} reads the second file (file1.csv) and prints each line followed by the corresponding value in the a array indexed by the second field

Maintenance by Kirokaze #pixelart

@mastohost gotcha. I went with DeepL given the free plan and my modest needs. I got it working. Thanks again for the help.

@mastohost Thank you very much! Do you have an opinion on which of the two APIs to use?

@mastohost @aral @eloquence @Gargron

Sorry for a slight threadjack here, but how do we enable translations as admins?

Is LibreTranslate and/or DeepL built into 4.x and we just need to add API keys? Or is there a third-party component that needs to be installed?

I can't find any documentation on it at docs.joinmastodon.org. I did find the PR at https://github.com/mastodon/mastodon/pull/19218, but I'd love to avoid parsing all the code if possible.

Crime, Fear, Death. Artist unknown. #pixelart