retrn a value from a string
Hi There,
Can you help please.
I have a table with fields that are key | value pairs.
I need to search the value field for a value and return a value between 2 characters.
So this is an example value "a:1:{s:15:"introducer_code";s:4:"6969";}"
I need to search for "introducer_code" and when found return the value "6969". This value can be any number so it might be a "1" or "16784" or anything so I need to be able to return the value between :" ";}" from the value shown above.
So I'm thinking it will be something using instring(len(Value)) or something like that.
Thanks for the help.
Best Regards,
Steve.
Subject
Written By
Posted
retrn a value from a string
February 08, 2019 05:31PM
February 08, 2019 07:31PM
February 09, 2019 06:54AM
February 09, 2019 09:50AM
February 10, 2019 01:40PM
February 10, 2019 03:03PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.