Skip to Content
avatar image
Former Member

Repeating Serial Number based upon Serial Number Qualifier

serialnumber-1.txtHi Experts,

we have an requirement where in the Serial Number should be repeated based upon the change of serial number qualifier pattern i.e., for every GM,R,R,R,R the value should be repeated.

let me explain you when an example

Below are the values what we have at source side

SerialNumberQualifier SerialNumber

GM 123456789

R

R

R

R

GM 456789123

R

R

R

R

GM 987654123

R

R

R

R

GM 963258741

R

R

R

R

GM 741258963

R

R

R

R

GM 852147963

R

R

R

R

At target side expected values

SerialNumber

123456789

123456789

123456789

123456789

123456789

456789123

456789123

456789123

456789123

456789123

987654123

987654123

987654123

987654123

987654123

963258741

963258741

963258741

963258741

963258741

741258963

741258963

741258963

741258963

741258963

852147963

852147963

852147963

852147963

852147963

So my requirement is after every for every GM,R,R,R,R its corresponding value should be repeated i.e., 123456789 repeated for first set of GM,R,R,R,R and so does other SerialNumber should be repeated as mentioned in target field.

Can anyone provide me UDF for achieving the above requirement

Regards

Faisal

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers