Hi everyone,
Is this possible?!
I am receiving form responses with strings of data in this format GYB23569RYF26985KIY89652, the actual length of the strings will vary. On form response, I need to split this string into GYB23569 RYF26985 KIY89652 so that each value is in a separate row in a column, with the corresponding form submission time in the adjacent column.
i.e.
| 22/06/2024 15:22 | GYB23569 |
| 22/06/2024 15:22 | RYF26985 |
| 22/06/2024 15:22 | KIY89652 |
Is this possible? I cannot find a way to divide a string without a known delimiter.

Report
All responses (
Answers (