Hi everyone
I’m using a Bubble plugin that converts an Excel file into a text string using ***
as the column separator and ,
to separate rows.
The problem:
When a cell in the Excel file is empty, the plugin doesn’t add the ***
separator for it, so the following data shifts into the wrong columns. This causes issues when I try to split
the row by ***
— I end up with fewer items than expected, and values get assigned to the wrong fields.
I know each row should have 13 columns, but since the separators are missing for empty cells (even in the middle), I can’t tell where the missing field is.
Has anyone encountered this before? Do you know a way to reliably detect the missing column or fix the line structure inside Bubble?
Any ideas or workarounds would be really appreciated
Thanks!