excel - How to remove or replace brackets in a string? -
my $book = spreadsheet::read->new(); $book = readdata ('d:\profiles\jmahroof\desktop\scheduled_build_overview.xls'); $cell = "cd7"; $n = "1"; $send = $book->[$n]{$cell};
the above code gets data spreadsheet, prints content of cell know has text in. has text of following format: text(text)
i need replace open bracket empty space , need remove close bracket. have tried below code substitute open bracket empty space not seem work.
$send =~ s/(/ /g; print $send;
the bracket seen part of code, escape it.
$send =~ s/\(/ /; print $send;
Comments
Post a Comment