Data Management Mapping Source to Target
Data Management mapping to pick up characters from between the string based on only 1 detail of the string
My source string is : sample data: 343434-2023
My target string is: Sample Data Created for example //qweryui /ryguh/test/qw15ABCc0749998997/test/ABCtest/name/3562374 837947 343434-2023 sample data/test/22-09-2023 19:24 1223456667778888
I need to map the source to target based on 343434-2023. Also not that in the source number of characters remain same. But target the number of characters will vary and I cannot set this as explicit mapping as these are thousands of lines of data coming from source system.