Quoting Text but not Numbers with arrayfilter()


#1

dumpdictionaryquoted( function will quote text but not numbers. How can I accomplish the same thing with arrayfilter()?

I want to accomplish the same result as dumpdictionaryquoted( but with arrays. The output will used in execute to assign values to variables.


#2

If I’m understanding you correctly, this formula should produce what you need:

?(stripchar(import(),"09..,,")=import(),import(),quoted(import()))

Notice I added the period and comma for the numeric check in case you have to catch both decimal and comma formatted numbers. If you will not encounter these you can eliminate them from the code.