creditcard-sublimetext-regex-replace.txt

-------------------------------------------
regex: ((([0-9]{2})(/)){2}([0-9]{4}))( )
replace: \1\t"
-------------------------------------------
regex: (([0-9]+)(,))*([0-9]+)(\.)([0-9]{2})
replace: "\t\2\4\5\6
-------------------------------------------
regex: ([0-9]+)(\.)([0-9]{2})( Cr)
replace: -\1\2\3

OR

regex: (([0-9]+)(\.)([0-9]{2}))( Cr)
replace: -\1
-------------------------------------------

Google Sheets - HDFC Points calculation


=IF(REGEXMATCH(B1,".*(SMARTBUY|FLIPKART|MYNTRA|SWIGGY).*"),IF(C1<0,50*CEILING(C1/150),50*FLOOR(C1/150)),IF(C1<0,5*CEILING(C1/150),5*FLOOR(C1/150)))

------------------------------------------------------------------------------------------------------------------------------