Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Answered

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

Posted on by 45

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

  • troyh1968 Profile Picture
    troyh1968 45 on at
    RE: I want to pass only part of a field when importing from .csv through xmlport NAV 2017

    Thank you Suresh. As always teaching me how to fish.

    Troy

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,638 on at
    RE: I want to pass only part of a field when importing from .csv through xmlport NAV 2017

    You can use the COPYSTR function, to get the portion of the string you want.

    docs.microsoft.com/.../copystr-function--code--text-

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans