Topics started by emrahbayar

2 Topics

E
Do Gooder (Customer)
emrahbayarDo Gooder (Customer)
asked in Data Migration

Data Migration FILE_STRING Error

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. 

1
M
Hero (Employee)
27 days ago
E
Do Gooder (Customer)
emrahbayarDo Gooder (Customer)
asked in Products (Manufacturing, Products, Engineering)

help with select statement (replace substr)

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___-____'

2
E
Do Gooder (Customer)
6 months ago

Badges

Show all badges
Terms & ConditionsCookie settings