question

ewinkiser avatar image
0 Votes"
ewinkiser asked KranthiPakala-MSFT commented

Having issues with Replace Function in QA Testing bug

Hi! @nasreen-akter @MartinJaffer-MSFT

Well, another QA bug that I "get" to solve :-)

All of our telephone numbers from our json data file are in the following format 787/215-1312 . I haven't worked with phone numbers and ADF expressions and have been trying to solve this. I do a lookup and get the following phonenumber "@{item().phonenumber}" which I use in a web activity to update employees phone numbers in Ceridian. I am trying a REPLACE function but having no luck. I have tried

replace( @item().phonenumber,'/','-') to get a phonenumber like 787-215-1312 but no luck. Any suggestions?

Thanks!
Mike

azure-data-factory
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ewinkiser,

Following up to see if you have got chance to review @nasreen-akter's feedback . Do let us know if you still need assistance on this.

Thanks

0 Votes 0 ·

Hi @ewinkiser,

We still have not heard back from you. Just wanted to check if the below suggestion was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·

1 Answer

nasreen-akter avatar image
0 Votes"
nasreen-akter answered

Hi @ewinkiser,

The expression you have is correct i.e., replace(@item().phonenumber,'/','-') and is working fine for me. Would you please check if the attribute name is phonenumber or phoneNumber? Thanks!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.