[ https://issues.apache.org/jira/browse/PIG-4673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Murali Rao updated PIG-4673: ---------------------------- Description: 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. was: 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. > 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)