News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) I want to pass only pa...

Microsoft Dynamics NAV (Archived)

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

(0) Share

Report

Report

Posted on by troyh1968

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

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

troyh1968 45 on at

Like (0)

Report

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 43,749 on at

Like (1)

Report

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

Leaderboard

#1

André Arnaud de Cal... 291,759 Super User 2024 Season 2

#2

Martin Dráb 230,468 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans