Anonymous

I've got these machine that output a lot of data. Unfortunately, the files outputted are structured in a strange way. I'd like to be able to do some complex text processing (perl style) to parse the data and be able to output to Excel format. I'd also like to automate this but the only server that I can use is running Windows XP (with Office) and I'm not allowed to install any extraneous software (no .NET, Powershell, ActivePerl, etc.)
What is the best way to do this? Are regex in VB/VBA powerful enough for me to script in Excel?

mailto:noko

Nothing? I've been looking around and it doesn't look like VBA can do perl-style regex and parsing of text files

Use Perl. http://stackoverflow.com/questions/936185/is-there-a-portable-perl

Thank you, I've already written a few text-parsing scripts in perl and this is very convenient. However, I don't know if IT will appreciate the 55MB size.

>>5
Can you run software directly from a USB drive? If so, then go install it onto one. If not, you're probably out of luck.

>>6
Of course. I'm fooling around with it now. Does strawberry perl support all the CPAN modules that regular perl supports? (like Win32::OLE and Spreadsheet::WriteExcel)

>>7
I wouldn't know. I found these answers in three seconds using google. http://bytes.com/topic/perl/insights/737530-how-install-setup-strawberry-perl

>>1
http://stackoverflow.com

JAVA