Update the Running No. after the import xml data

Rathi

Hi Guys,

Anyone knows how to update data for Item No after import .xml file.

I need to update the running No.

(Eg: Import from .xml --> FP-NP_SYR)
1. Current data in Item table is FP-NP-SYR-001
2. New import Data update into system --> FP-NP-SYR-002

How to modify the updated data FP-NP-SYR into FP-NP-SYR-002


Thanks in Advance.

Jan_Veenendaal

This is what the INCSTR function is for.

https://msdn.microsoft.com/en-us/library/dd338972(v=nav.90).aspx

zohaibu95@hotmail.com

@Rathi, Use the INCSTR function
For reference: https://msdn.microsoft.com/en-us/library/dd338972(v=nav.90).aspx

RockWithNAV

Yep go ahed with INCSTR - INCREASE STRING
It will increase the last integer value by 1

SuD

Yup,INCSTR is the solution for your requirement ..eg.INCSTR( 'FP-NP-SYR-001')..