Re: String cuts in column data

[Peter Brawley]

If you're a regular regex user in a real language (eg Perl, PHP, C), that'll be easier, otherwise it's just a few lines of brute force string parsing ...

set @s = "[CALL DATE : 11/23/2015] [CONTACT NAME : venki palama] [SERVICE REP NAME : sudhakar mare] Please send a picture showing the overlay harness and connections made";

set @stop = locate("]",@s,1);
set @calldate = trim( substr( @s, 14, @stop-14 );

set @start = locate("[",@s,@stop);
set @stop = locate("]",@s,@start);
set @preflen = length(" [CONTACT NAME ");
set @contactname = trim( substr(@s, @start + @preflen, @stop-@start-@preflen) );

set @start = locate("[",@s,@stop);
set @stop = locate("]",@s,@start);
set @preflen = length(" [SERVICE REP NAME ");
set @servicerepname = trim( substr(@s, @start + @preflen, @stop-@start-@preflen) );

set @comment = trim( substring_index(@s,']',-1) );

select @calldate, @contactname, @servicerepname, @comment;

Easy to make a func of it, call it as often as you please.