Forum Academy Marketplace Showcase Pricing Features

Need help with trimming data

I’m doing a spotify API Get, which returns “Spotify:Artist:(id needed)”

How do I trim the “Spotify:Artist:”, leaving me with just the (id needed), when writing to the database. Please help.

Thank you

Hey :wave: @joshsgalbreath

Try find and replace “Spotify:Artist: with an empty field. Probably need two find and replaces. Find and replace “ with an empty field as well. It’s either that or use regex i think. :blush:

Would that work?

This seemed todo the trick. Thank you!

1 Like

Awesome, glad it helped! :blush:


For All Your No-Code Education Needs: