Have you tried using replace function to modify the contents as per https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TableMapping.SelectionTransformation.Expressions.html#:~:text=%3A%2050%0A%7D%0A%7D-,Using%20SQLite%20functions%20to%20build%20expressions,-You%20use%20table
The replace(x,y,z) function returns a string formed by substituting string z for every occurrence of string y in string x.
I hope it helps.
AWD DMS Replace Characterasked 15 days ago
Does AWS DMS work with Oracle 21c express editionasked 8 months ago
Is it possible to check the connection after setting the AWS DMS target endpoint as a server of another Cloud Service Provider?asked 3 months ago
Requirement for continuous_mine functionality for Oracle 19 DMS as sourceasked 3 months ago
Support for RDS Oracle as source while using DMS SCN for CDCAccepted Answerasked 4 years ago
Can DMS be used to extract data from an RDS Oracle Read Replica?Accepted Answerasked 2 years ago
DMS for Replicating Data in Oracle Application Containerasked 7 months ago
DMS - Oracle Binary Reader LatencyAccepted Answerasked 4 years ago
AWS DMS - Data from Oracle EBS database - from Viewasked 2 months ago
S3 Integration Oracle RDS and DMSAccepted Answerasked 2 years ago