ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: omerix on June 14, 2019, 03:39:11 pm

Title: colmodel pq_fn
Post by: omerix on June 14, 2019, 03:39:11 pm

https://yadi.sk/i/ExBZ1ISFSIfCpQ


I want to print the value in "(xxx)" in the "Note" field to another field.

I can find it when I write the value to the cell, but I can't figure out how to do it.

colModel

Code: [Select]

,{title: 'Value', width: 150,dataType:'string',pq_fn: {'=MID(B7,FIND('(',B7,0)+1,(FIND(')',B7,0)-FIND('(',B7,0))-1)'} }


Title: Re: colmodel pq_fn
Post by: paramvir on June 18, 2019, 10:12:30 am

Excel formula is probably an overkill for this.

regular expression can be used in column.render or column.formula callbacks to extract value between () of other column.