Easy Way to Substitute Invalid Filename Characters?

[PocketSurvey]

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?

[Marc_Dillon]

PocketSurvey:

Is there a concise expression to substitute invalid characters, without having to use lots of nested SUBSTITUTE functions?

I don’t think so.

[Steve]

If you’re using Google Sheets, you could use REGEXREPLACE(). I dunno if Excel has that function.

[Sara_Bertomeu]

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

[graham_howe]

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).

[Sara_Bertomeu]

ok, @graham_howe thanks, now it's clarify. 

So, the only way it's Substitute.