how to extract line/sting from long [message #379679] |
Wed, 07 January 2009 11:00  |
pp56825
Messages: 4 Registered: January 2009 Location: Warsaw
|
Junior Member |
|
|
I have a table with column "message" type long.
i want to extract field begin with :21: and display it in sql select
example of message:
{1:12360418LHJK1G325H14}
{2:XXXXXXXXXXXXX1XXXXX}
{4:
:20:SFIH235139H145
:21:G2345YOG12U5
:79:XXXXXXXXXXXXX 211323 324123 XXXXXXX
OUR REF 15143145XXX346134
I want to extraxt only this info
:21:G2345YOG12U5
in select or view
|
|
|
|
|
|
|
|
Re: how to extract line/sting from long [message #380109 is a reply to message #380101] |
Fri, 09 January 2009 03:19  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
The function definition you showed has 4 parameters, you give it 3 parameters, so what is your problem with the error message?
Use the correct function (t_substr in the link).
Note that anyway you are limited to LONG value less than 32K.
Regards
Michel
|
|
|