Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › how to strip a transaction ID out of a string of characters?

View all replies to this thread

how to strip a transaction ID out of a string of characters?

Thread began 11/07/2019 10:56 am by Nathon Jones Web Design | Last modified 11/18/2019 9:59 pm by Nathon Jones Web Design | 209 views | 11 replies

11/18/2019 9:59 pmRay BorduinWebAssist

I'd do it with a .php page. Doing it entirely from SQL would be difficult.

Create a recordset to get all of the results.

Use json_decode() to get the string transformed to an object or array.

Then update the column you need in the same loop with the value from the object.

I don't have any tutorials on this topic.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.