question

ewinkiser avatar image
0 Votes"
ewinkiser asked ewinkiser commented

Need to Remove periods in an ADF Expression

HellO! @nasreen-akter @MartinJaffer-MSFT

I have the following string: 90412-image.png and need to remove the periods for a string variable in my ADF Pipeline. These expressions are the hardest part for me. Any suggestions? The string should read:
110100120350

Thanks!
Mike Kiser


azure-data-factory
image.png (711 B)
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.

1 Answer

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

Hi @ewinkiser,

You can try replace() e.g.,

@replace('1.10.100.120.350', '.', '')

Thanks!

· 1
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.

Thanks @nasreen-akter !! It worked perfectly!
Mike

0 Votes 0 ·