Alternatively to the “Replace in string”-Step, the “Modified JavaScript value”-Step can be used to replace something in a string. eg. here to replace a carriage return with a white space:
var Author = replace(Author_seperated, “\r”,” “)
Notes about using Pentaho Data Integration and Apache Hop as Non-Programmer
Alternatively to the “Replace in string”-Step, the “Modified JavaScript value”-Step can be used to replace something in a string. eg. here to replace a carriage return with a white space:
var Author = replace(Author_seperated, “\r”,” “)