mibuso.com
Home› NAV Three Tier
Options

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

troy.harkness@hotmail.comtroy.harkness@hotmail.com Member Posts: 11
in NAV Three Tier
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

Best Answers

  • Options
    troy.harkness@hotmail.comtroy.harkness@hotmail.com Member Posts: 11
    Answer ✓
    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

Answers

  • Options
    troy.harkness@hotmail.comtroy.harkness@hotmail.com Member Posts: 11
    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.
  • Options
    troy.harkness@hotmail.comtroy.harkness@hotmail.com Member Posts: 11
    Answer ✓
    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
Sign In or Register to comment.