I'm a total newbie only starting to use the tool yesterday!
I have a simple CSV input file where I want to replace the values in one column with a different value. The field currently contains values such as "Y", "N", "NA", blanks etc. I want to replace these with "XXX", "YYY", "ZZZ" etc.
I have used the Reformat Transformer to apply replace($in.0.Part,"Y","XXX") but I just get an error. The field is a string.
The source code looks like this $out.0.Part = replace($in.0.Part,"Y","XXX");
I have applied the same syntax to another field which is also a string and it works..... replacing "-" with "/" for example.
I can't see what I'm doing wrong.... any advice you can give would be greatly appreciated as I'm already pulling my hair out!