[ https://issues.apache.org/jira/browse/PIG-2905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bill Graham updated PIG-2905: ----------------------------- Resolution: Fixed Status: Resolved (was: Patch Available) Committed, thanks Cheolsoo! > Improve documentation around REPLACE > ------------------------------------ > > Key: PIG-2905 > URL: https://issues.apache.org/jira/browse/PIG-2905 > Project: Pig > Issue Type: Sub-task > Components: documentation > Reporter: Bill Graham > Assignee: Cheolsoo Park > Attachments: PIG-2905.patch > > > Document how REPLACE uses a Java regex and link out to JDK docs describing > reserved characters and escaping. From recent confusion on the users list: > {noformat} > > String source = "[02/Aug/2012:05:01:17"; > > > String target ="["; > > > String replaceWith = ""; > > > return source.replaceAll(source, target, replaceWith); > > Note that Java String.replaceAll() takes a regular expression for the 2nd > > parameter (i.e. target), and "[" is a special character. To use it as is, > > you have to escape it, so in your Pig script, you should do: > > REPLACE(date,'\\[','') > {noformat} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira