0

How can I replace a pattern in a string in one column with a value from another column in Cloud Dataprep?

To be precise, I have a column A with the same pattern in every string of the column, and I want to replace that pattern inside a string with corresponding value (when i say corresponding I mean the value in the same row) from another column.

Any idea?

zerina
  • 131
  • 1
  • 1
  • 4

1 Answers1

0

I think you should be able to do this in two steps:

1.- Splitting the column (using the pattern in order to take it away)

2.- Merging the column (gathering the pieces together into the one desired column)

Temu
  • 859
  • 4
  • 11