Look up and string operation; fetch a value based on searching a partial string
- by Sam
I have 2 sets of data. One set to be filled up by fetching relevant data from a data array.
DATA to be FILLED:
Part#1 Part#2
------ -------
4021006
3808587
3870480
3083410
3873905
3890030
4002065
3699803
3930218
ARRAY OF DATA:
Part#1 Part#2
------ -------
4021006;3808587 1
3808587 2
3870480;3083410;4002065 3
3083410 34
3873905 54
3890030 32
4002065;3930218 65
3699803 75
3930218 68
I need to match Part#1 and find Part#2.
EXPECTED OUTPUT
Part#1 Part#2
------ -------
4021006 1
3808587 1;2
3870480 3
3083410 3;4
3873905 54
3890030 32
4002065 3;65
3699803 75
3930218 65;68
Can anyone help.