[SOLVED] Modifying data already in the database?

[fayewatson]

No problem! Nigel’s post here has the correct regex to use:

Convert text to list

(\b[^\s]+\b) However, that will just match on words with boundaries on letters. Should be fine for most situations, but really depends on what you are trying to do, and what you want to do with punctuation etc.

I did a quick example with the file name example you gave, which first replaces the hyphens in the string with spaces, extracts it with regex in a multiline input, and then displays each segment in a repeating group:

Editor:

Bubble Editor - faye-demo-app

Preview:

Bubble - Visual Programming

If you’d like to save different parts of that file name to different fields, you could reference the parts using ‘item #’ from the repeating group. Is this what you were trying to set up?