Objective: Extract Currency Value (not Date) from given file. Content of file: [["1234567890","Your previous month point is QR 5,200.33.Your current month point is QR 1,15,200.33, Last Year total point earned QR 5589965.26 and point lost in game is QR -11520 your this year subscription will expire on 19-04-2013. 9. Back"]]
What I have done so far: def read_file(): fp = open('D:\\ReadData2.txt', 'rb') content = fp.read() data = eval(content) l1 = ["%s" % x[1] for x in data] return l1 def check_currency(l2): import re for i in range(l2.__len__()): newstr2 = l2[i] val_currency = [] val_currency.extend(re.findall(r'([+-]?\d+(?:\,\d+)*?\d+(?:\.\d+)?)',newstr2)) print " List %s " % val_currency for i in range(len(val_currency)): val2 = val_currency[i] remove_commas = re.compile(r',(?=\d+)*?') val3 = remove_commas.sub('', val2) print val3 if __name__=="__main__":main() Ouput of check_currency: >List ['5,200.33', '1,15,200.33', '5589965.26', '-11520', '19', '-04', '-2013'] Expected Ouput of check_currency: List ['5,200.33', '1,15,200.33', '5589965.26', '-11520'] Problem with output: I am getting date in currency value which it should not. What alteration should I do in my regex to complete??? Thank You Regards Dharmjeet Kumar This e-mail and all material transmitted with it are for the use of the intended recipient(s) ONLY and contains confidential and/or privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies and the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken pursuant to the contents of the present e-mail is strictly prohibited and is unlawful. The recipient acknowledges that Comviva Technologies Limited or its management or directors, are unable to exercise control or ensure the integrity over /of the contents of the information contained in e-mail. Any views expressed herein are those of the individual sender only and no binding nature of the contents shall be implied or assumed unless the sender does so expressly with due authority of Comviva Technologies Limited. E-mail and any contents transmitted with it are prone to viruses and related defects despite all efforts to avoid such by Comviva Technologies Limited.
_______________________________________________ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32