Regular Expressions 101

Community Patterns

XLS Sheet :replacement with Regex

1

Regular Expression
PCRE (PHP <7.3)

/
([\\\/\?\[\]\*]+)
/
g

Description

This expression will be useful to distinct group of Special characters making a blocker while creating the sheet though code

e.g IF sheet name is given XXX/[abc]/YYY name through code.It must be renamed as such naming is not allowed in XLS.

Submitted by Reshma Nehlani - 8 years ago