[ https://issues.apache.org/jira/browse/PIG-4673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14739882#comment-14739882 ]
Daniel Dai commented on PIG-4673: --------------------------------- Sounds useful to have it in piggybank. I can review it once you put a patch. > 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 > Reporter: Murali Rao > Assignee: Murali Rao > Priority: Minor > > 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('ABCD','A','1'),'B','2'),'C','3'),'D','4') > With proposed UDF : REPLACE_MULTI method > General Syntax : > REPLACE_MULTI ( sourceString, [ search1#replacement1, ... ] ) > REPLACE_MULTI ( 'abcd', [ '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)