How to bring all np_category in to one filed !!!

[#1]

Hi All

I have one filed it will contains all delimiters in that field so now my question is i have retrieve all fields which ever contains staring with np_telugu,np_english like that into one category

I archived that  by using wildmatch() it ids giving correct but i have more than 1000 strings are there like that

by giving wildmatch() my expression will by very huge 

    so can any one help me is the any way to get all np_fields in to one category please let me know that will grate for me

please look at below at  file it is having  np_filed :

ln_bangla"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""news"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""notification"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_abp"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""overall"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 } }"

"{ ""ln_bangla"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""news"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""notification"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_abp"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""overall"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_prothom"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 } }"

"{ ""ln_bangla"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""news"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_abp"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_kaler"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""overall"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_bbcbang"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 } }"

"{ ""ln_bangla"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""news"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_abp"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""overall"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 } }"

"{ ""ln_bangla"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""news"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_abp"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""overall"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_bbcbang"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 } }"

"{ ""ln_bangla"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""news"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_abp"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""overall"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_prothom"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_bbcbang"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 } }"

"{ ""ln_bangla"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""news"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_bhaskar"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""overall"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""ln_hindi"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_bbcbang"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 } }"

"{ ""ln_bangla"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""news"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_dwbangla"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_abp"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_patrika"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""overall"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""ln_hindi"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 } }"

"{ ""ln_bangla"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""news"" : { ""dt"" : 20141001, ""dd"" : 1, ""yymm"" : 1410 }, ""np_dwbang

Thanks

Manju

[#2 · Accepted solution]

mid(Collection_last_access,Index(Collection_last_access,'"np_'),20) as temp_np

[#3]

Hi

For AlternateWay PFA,

[#4]

Hi Harshal,

             Thanks For reply it is working fine here the problem is it is not finding if it is finding in 2nd time in same  line

Like (np_eendu in the same line have one like np_sakshi ) in that case how will do

please look at below line:

{ "np_mbhu" : { "dt" : 20141012, "dd" : 12, "yymm" : 1410 }, "np_mano" : { "dt" : 20141012, "dd" : 12, "yymm" : 1410 }, "news" : { "dt" : 20141012, "dd" : 12, "yymm" : 1410 }, "overall" : { "dt" : 20141012, "dd" : 12, "yymm" : 1410 }, "ln_malayalam" : { "dt" : 20141012, "dd" : 12, "yymm" : 1410 } }

that above line contain to np's in same line but is is giving only one I,e: np_mbhu it is giving first occurrence

can u plz let me know

Thanks

Manju

[#5]

hi manju,

PFA,