Hi,
Could I get help with the following so I can avoid creating multiple concat with left and right to do the following -
To perform successful join I need remove a value from the middle of my production file.
Product_Code
634020030410 – Load file
63402030410 - Production
I wanted to avoid -
left(product_code,6)
right(product_code,5)
To make -
concat(left(product_code,6),right(product_code,5))
Remove value from middle of string
Posted - 12/08/2012 : 07:24:25
