match the lists and select the code.list –i    list – iia. exarch    i. rhizome of pterisb. endarch    ii. roots of pterisc. mesarch    iii. pinnule of cycasd. pseudo-mesarch    iv. primary stem of pteris
a - ii, b - iv, c - i, d - iii
hi [@maddy](/u/maddy),

i believe the issue here is that you've specified order here but not the filed to order it by, to quote the docs:

you use two parameters for this argument: field to specify the prismic field id and order to specify if you want it sorted ascending (asc) or descending (desc). you can use… [@cssc](/u/cssc), another option would be to take the regex way.

first, it finds the index of the 5th pipe.

then, it takes the substring until that index.

give this a try:

inputstr.substring(0, regex.matches(inputstr, "\|")(4).index + 1) sin(theta) = d, 
cos(theta) = a, 
tan(theta) = h, 
csc(theta) = f, 
sec(theta) = c, 
cot(theta) = g. 1 a c d
2 a
3 c
4 b
5 c
i got a 100% information is below. you can find a wretch on the upper right corner.

pin is what you are searching for. (banner will put the post above topic list. see gradle forum.) The next shapes in the ‘growing’ pattern are as follows:


![](https://mathsgee.com/?qa=blob&qa_blobid=5951663371716016349) dear student

kindly refer to the link for the similar query :


https://www meritnation
com/ask-answer/question/q-23-and-24-q23-give-the-formula-of-each-of-the-follow/the-p-block-elements/11940305

regards like this?

select a.itemcode

,isnull(c.citemname,b.itemname)

from produceitem as a

left outer join mastertable as b

on b.itemcode=a.itemcode

left outer join customeritemtable as c

on c.itemcode=a.itemcode

; its kind difficult to understand in my POV but not impossible  

imagining it while reading


can you show some codes? or samples on what you want to achive?