So, we are building an app to get out of previous SaaS that will hopefully work better. One of the steps was to import the data from our SaaS into the our bubble app. This has been done, but there is a problem with the data; many of the ‘types’ are clumsy. So, for example, addresses are one ‘field’ and written out such as ’ 123 main st// sometown// state// zip’.
What I want to be able to do is to parse all of these addresses, phone numbers, names, etc, into their own ‘field’/column in the database. Using the example above, I would like to make each bit of data in between the slashes have it’s own column such as ‘street number’ ‘rm number’ ‘city’ ‘state’ ‘zip’, without having to reenter all this info. Especially having this info still associated with the same use?
Is this possible with a work flow?