Informatica: Data in column looks like 00003242-2-0-1,00000925-1-0-1,00003214-2-0-1 .In target I need data like 3242, 0925, 3214 in different rows

Data in one column looks like this

00003242-2-0-1,
00000925-1-0-1,
00003214-2-0-1.

In target I need to get only data like

3242, 
0925, 
3214 

in different rows. How can I achieve this using informatica mapping?

1 answer

  • answered 2022-05-06 14:51 NickW

    Just use a SUBSTR function in an Expression transformation

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum