Import - Examples & Best practices

Check a lenght of an incoming field

Question

Need assistance with importing items that may have a character length of more than 20 characters.

If the imported value is > 20 characters, then I want to us another field value. For example want the NoSeries to assign a value to the No. field. If the length is <=20, then use the imported value.

Solution

Firts you need to get and set in another field the item no series that you want to use in case it is larger then 20 char.

Then with the function STRLEN you can count the amount of characters from the itemno. from the import file.

After that use the function ifgreater to check if it is larger then 20 char. When true the new item no that is set with the no. series from BC can be used. If false, the value of the item no. from the file can be used.