Regular Expression -
replace(each_item,'(\.|\,)(\d+)(\.|,)','\2.','(\d+)(?:\.|,)(\d\d\d)','\1\2',',','.')
Note : - It is used to replace , and . in currency and make them proper
replace(each_item,'(\.|\,)(\d+)(\.|,)','\2.','(\d+)(?:\.|,)(\d\d\d)','\1\2',',','.')
Note : - It is used to replace , and . in currency and make them proper
No comments:
Post a Comment