SaskiaV

Discussions

Email Connector: Unable to figure out why my regex not working
Dear DOMO community, I am at a loss and don't understand why in my email connector the regex .*PANAY.* will work when email subject is Fw: MSPANAY GROUP |IBITEM AND AVAIL - 9/8/2023 7:17:56 am but it fails when the email subject is Fw: MSPANAY GROUP | Ibitem, Price Change and Avail - 8/28/2023 7:54:21 AM When checking…
Email Connector: Way to ignore #N/A fields in xls files ?
I am using the email connector to send .xls files to DOMO. There were some fields in the excel file that contained "#N/A" and they were automatically converted to "ERROR 42" in the dataset that was created and caused my downstream dataflow to fail. Is there a way to have the connector somehow ignore #N/A fields or convert…