Is there a concise expression to substitute invalid characters, without having to use lots of nested SUBSTITUTE functions?
Lots of characters cause problems when creating file names, such as : \ ? < > โ / * etc
I want to substitute all these and more with - (dash) without having to do lots of nested substitutes?
Any ideas?
I donโt think so.
If youโre using Google Sheets, you could use REGEXREPLACE(). I dunno if Excel has that function.
Hello boys,
So How you explain we can use REGEXREPLACE with Appsheet, but I try to write REGEXREPLACE([data X];" ";"U+005F")), and it says that it's not valid.
Any idea??
Thanks
AppSheet doesn't have Regular Expression capabilities, @Steve was talking about using the expression in the backend data source, either Google Sheets (where it is built in) or Excel (where I think it is included in an add in).
ok, @graham_howe thanks, now it's clarify.
So, the only way it's Substitute.
User | Count |
---|---|
42 | |
29 | |
28 | |
14 | |
14 |