Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data load mapping using SQL Replace

in Planning 6 comments

Hello experts,

I have a doubt doing a specific Mapping in DM

I have in my source this kind of accounts (Source-Account column):

I need to create a mapping that FIRST underscore was a "L" instead of _ (You can see in example that exists accounts that have two (746_01_SI2) in this case I would like to see: 746L01_SI2

I have a lot of accounts with this caracteristic and also with just one "_".

I can do that via import format like this: replace(UD2,"_","L") but all "_" are converted. So there is a code that can I use in SQL to convert just first?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!