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
You can use the COPYSTR function, to get the portion of the string you want.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
288,768
Super User
#2
Martin Dráb
225,985
Super User
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (