[ https://issues.apache.org/jira/browse/PIG-4673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14790765#comment-14790765 ]
Murali Rao commented on PIG-4673: --------------------------------- [~daijy] : Attached patch, plz check and let me know your inputs. > Built In UDF - REPLACE_MULTI : For a given string, search and replace all > occurrences of search keys with replacement values. > ------------------------------------------------------------------------------------------------------------------------------ > > Key: PIG-4673 > URL: https://issues.apache.org/jira/browse/PIG-4673 > Project: Pig > Issue Type: New Feature > Components: piggybank > Affects Versions: site > Reporter: Murali Rao > Assignee: Murali Rao > Priority: Minor > Labels: None > Fix For: site > > Attachments: replace_multi_udf.patch > > > Lets say we have a string = 'A1B2C3D4'. Our objective is to replace A with 1, > B with 2, C with 3 and D with 4 to derive 11223344 string. > Using existing REPLACE method > REPLACE(REPLACE(REPLACE(REPLACE('A1B2C3D4','A','1'),'B','2'),'C','3'),'D','4') > > With proposed UDF : REPLACE_MULTI method > General Syntax : > REPLACE_MULTI ( sourceString, [ search1#replacement1, ... ] ) > REPLACE_MULTI ( 'A1B2C3D4', [ 'A'#'1','B'#'2', 'C'#'3', 'D'#'4' ] ) > Advantage : > 1. Function calls are reduced. > 2. Ease to code and better readable. > > Let me know your thoughts/ inputs on having this UDF in Piggy Bank. Will take > this up based on this. -- This message was sent by Atlassian JIRA (v6.3.4#6332)