Skip to main content
Microsoft Dynamics NAV forum
Answered

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

editSubscribe (0) ShareShare
ReportReport
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,636 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

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans