I have a group of part number doesn't come with a standard format. It is very tricky since some does come with some regular flow but some are not. Therefore i try to take 2 different sample category and hope you guys able to provide me some advice. Preferred method in Access formula as i'm not familiar with VDA.
My idea is to split the LPN into 3 column eg. CIVUS (Type), 0.13(SIZE), BR (COLOR)
TRA_LPN TYPE SIZE COLOR
CIVUS-0.13-BR
AVS3.0G-B
AVSSH-2.0F-G
TRA_LPN
AGP0219-2.5-GY-O
FLRYY-4X0.75-B
V-R2-0.75-W
V-R2-0.75-Y

My idea is to split the LPN into 3 column eg. CIVUS (Type), 0.13(SIZE), BR (COLOR)
TRA_LPN TYPE SIZE COLOR
CIVUS-0.13-BR
AVS3.0G-B
AVSSH-2.0F-G
TRA_LPN
AGP0219-2.5-GY-O
FLRYY-4X0.75-B
V-R2-0.75-W
V-R2-0.75-Y