Base64 decoding multiple lines

[audi321]

Hi all, does anyone know how best to decode a number of excel lines which are in Base64 encoded text (UTF-8)?

I've found an online decoder, but it only does one line at a time and I have hundreds.

Thanks for any advice!

Edited by audi321 on Thursday 23 July 17:57

[Taita]

If you have a Linux box (or Windows Subsysetm for Linux)

cat file.txt (containing all the limes) | base64 -d > outfile.txt

May need some form of for loop to do each line, rather than cat thinking it is ONE big line instead of 1000 of little lines although I'm fairly sure there is a flag for that.

Or Powershell has options too (and may be able to deal with a CSV input if you convert your XLS to a CSV in advance?

https://stackoverflow.com/questions/15414678/how-t...

[grumbledoak]

VBA?

https://stackoverflow.com/questions/169907/how-do-...

[maffski]

audi321 said:

I've found an online decoder, but it only does one line at a time and I have hundreds.

This one any help?

[audi321]

maffski said:

This one any help?

Perfect yeah thanks! Copied loads of lines, clicked the separate lines box and boom. Thanks again!