Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

How do I replace a value in a string?

Is there a transformation component that can be used to replace a value in a string? Say I have a number provided with a comma instead of a decimal point and I want to replace the character, how do I do this?

2 Community Answers

Graham Lannigan —

Never mind, I've got it - string functions are available in the "Calculator" transformation.

The name's a little misleading I think!


Matillion Agent  

Ian Funnell —

Hi Graham,

Matillion is an ELT tool, so these kinds of transformations would be performed inside Redshift, using SQL commands generated by components in a Transformation job.

The Calculator is the component to use for this purpose, and I’ve attached a small example (StringManipulation.json) which you can import (Project/Import) to demonstrate a couple of different ways to do this.

Best regards,
Ian

Post Your Community Answer

To add an answer please login