Re: Excel > Data > Text to Columns (Win32::OLE)

See if this works

$output =~ s/ +/\t/g;
my $CLIP = Win32::Clipboard();
$CLIP->Set($output);
[download]

poj

Comment on Re: Excel > Data > Text to Columns (Win32::OLE) Download Code

Replies are listed 'Best First'.
Re^2: Excel > Data > Text to Columns (Win32::OLE) by davies (Monsignor) on Apr 29, 2014 at 14:20 UTC
If this does what I think it does, converting spaces to tabs, all this will change is the delimiter needed in the code I posted. It's possible to tell each of the delimiters whether they should be on or off, and mix & match your own to suit. Regards, John Davies	[reply]
Re^2: Excel > Data > Text to Columns (Win32::OLE) by Bascule (Initiate) on Apr 29, 2014 at 14:23 UTC
Haha! Yes, that did the trick. Thanks. Now I have a couple of options..	[reply]
Re^3: Excel > Data > Text to Columns (Win32::OLE) by Bascule (Initiate) on Apr 29, 2014 at 14:29 UTC
Actually, just adding the one line meant that my paste worked fine as it was. `$output =~ s/ +/\t/g;`	[reply] [d/l]