I want to pass only part of a field when importing from .csv through xmlport NAV 2017

troy.harkness@hotmail.com

I have data that will be coming from an outside system to be imported. The file will look like this;

"9000","01-TEST"
"60260","01-TEST"
"60420","01-TEST"
"60012","01-TEST"
"60215","01-TEST"
"60290","01-TEST"
"60164","01-TEST"

Item No.,Bin Code (This is the fields)

I want to only pass into NAV "TEST" just ignore the "01-"
I have been able to figure out Concatenate to pass the data to the outside software but I am stumped on how to parse this apart.

Thank you,
Troy

KTA8

on the import after getting data use COPYSTR. Something like myvar:=COPYSTR(testtext,4)

troy.harkness@hotmail.com

KTA8 with your help I figured it out. I found the COPYSTR "How to". I understand now that if you only give position with no length everything from given position to the end of the string will be passed.

Thank you VERY much.
Troy

KTA8

on the import after getting data use COPYSTR. Something like myvar:=COPYSTR(testtext,4)

troy.harkness@hotmail.com

There is one thing I just realized and that is the data that I need to pass will vary in length. These are bin code so they will be anywhere from 4 - 10 digits in length.

troy.harkness@hotmail.com

KTA8 with your help I figured it out. I found the COPYSTR "How to". I understand now that if you only give position with no length everything from given position to the end of the string will be passed.

Thank you VERY much.
Troy