Hi,I will transfer data with the Excel program, but I get the error in the picture.1.I convert the Excel file to csv file.2. Start Job - Load File / I select and load the file and I get the error in the picture.
I just want to change Character 18, but this goes and changes everything it finds related to Character 18. Org. text USMCAE*20L080M4D-0000In the example below, the line of code returns the data as follows : USMCAE*2ELE8EM4D-EEEEmust be : USMCAE*20L080M4D-E000 select replace(mx.component_part, substr(mx.component_part, 18, 1), 'E') from prod_structure mx where mx.part_no like '___080___-__-__-___' and mx.component_part like 'US____*___080___-____'
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.