LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dducharme

Hello,
I keep getting the following on an Excel output node. It's been working all along and now this comes up below.
Any help would be great Thank You


WARN: Error decoding byte buffer

WARN: Error decoding byte buffer

ERROR: Unexpected error occurred during processAll while running the node: Error decoding byte buffer.
Error Code: brain.unexpectedNodeErrorDuring

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: CPereira

This is usually due to special characters in your excel file. Here's how I would approach --

First, I would do a regex substitute (eg in a filter node) like Data_noPunct = Data.regexSubstitute("[[:punct:]]","") to get rid of any punctuation that the node may be having trouble parsing.

If that doesn't work, it may be the case that you have foreign characters that LAE can't decode, and you need to get rid of them using something like Data_alphaNumsOnly =Data.regexSubstitute("[^A-Za-z0-9]",��) - this way is a bit extreme though, since it gets rid of anything that is not an alphanumeric character, but you can play around with this regular expression to include other characters you need in the file.

Let me know if that doesn't work either or if you need to modify the regex and I'm happy to help