Dont Scold Me Annaya's

[ChampakDas]

https://www.debuggex.com/

 

first dantlo paste e thisd : ^.*(?=(result_set;))

 

result dsantlo what you told ;w;y;i,;result_set;l          

[tejak123]

moodu peg lu pad ak antha maska maska

 

TS edi use chey i  ^.*(?=(\result_set))..//

 

 this is correct but doesnt select columns where there is no results_set.. :(

[ChampakDas]

 

moodu peg lu pad ak antha maska maska

 

TS edi use chey i  ^.*(?=(\result_set))..//

 

 this is correct but doesnt select columns where there is no results_set.. :(

 

 

[ChampakDas]

enjoy with pictorial workflow

https://www.debuggex.com/r/ssqi9NjXcAHVDsbx

 

 

[tejak123]

enjoy with pictorial workflow

https://www.debuggex...sqi9NjXcAHVDsbx

 

..// thanks annay

[ChampakDas]

jambal heartu raja

 

enjoy with pictorial workflow

https://www.debuggex...sqi9NjXcAHVDsbx

 

..// thanks annay

 

 

[puli_keka]

do festival

 

^[\s\S]+?(?=($|(,;result_set;)))

 

 

nee input data ki work avuthundi .. try for more input

[puli_keka]

www.regexper.com/#%5E%5B%5Cs%5CS%5D%2B%3F(%3F%3D(%24%7C(%2C%3Bresult_set%3B)))

 

nenu ee site vaadathanu for clear description about regex..  click on it..  using look ahead  ?=    adhi result set or end of line reach avvagane aagipothundi    inko question mark greedy so it matches that line only..  hav fun

[TOM_BHAYYA]

[tejak123]

idhi chudandi boss

REGEX for selecting rows which has 1 , any inbuilt function undha.???

 

INPUT: 

5,9,4,7,6,3,1,6

9,14,68,79,3,4

5,9,6,8,3,5,11,6

4,1,789,23,7,9

 

I should have rows which have only 1

 

OUTPUT:

 

 

5,9,4,7,6,3,1,6

4,1,789,23,7,9

 

 

[puli_keka]

idhi chudandi boss

REGEX for selecting rows which has 1 , any inbuilt function undha.???

 

INPUT: 

5,9,4,7,6,3,1,6

9,14,68,79,3,4

5,9,6,8,3,5,11,6

4,1,789,23,7,9

 

I should have rows which have only 1

 

OUTPUT:

 

 

5,9,4,7,6,3,1,6

4,1,789,23,7,9

 

 

nuvvu em try chesav em ravatledu ikkada vey..  google lo    regular expression select line contains string    kodithe evo results vachayi..  so nuvvu chusi try chesi ekkada fail avuthundo cheppu

[tejak123]

'(?=.*?\b(,1|1,|1)\b)(.*)\w+'    idhi test site lo saripothundhi... but query lo error vasthundhi

[tejak123]

(?=.*?\b(,1|1,|1)\ b )(.*)\w+ 

[puli_keka]

'(?=.*?\b(,1|1,|1)\ B)(.*)\w+'    idhi test site lo saripothundhi... but query lo error vasthundhi

regexpal.com  or notepad++ lo nee testdata tho test chey..   sometimes invalid regular expression ani error vasthadi