ADF-Mapping Data flows

Question

Hi,

I have a requirement that in my source in some of the fields of string type, we have string starting and ending with single quotes (') for example like 'abcdefgh'. In mapping dataflows, we need to check that the string is starting and ending with single quotes, if yes, then both the leading and trailing single quotes must be removed.

How can this be achieved in mapping dataflows. Any help is appreciated!

Answer 1

Hello @Madugundu Somashekara, Roopa ,

Thanks for the question and using MS Q&A platform.

You can use trim() function in your expression to remove leading and trailing characters.

Use this expression and it should help remove trailing and leading characters

trim(sourceColumnName, '\'')  

Here is a sample:

In case if you have single quotes or a special character anywhere in the give string then you can use replace() function. Please see example below:

replace(souceColumnName, '\'', '')  

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how