How can I concatenate two fields into one?

Perizat_ShatyrbekovaPerizat_Shatyrbekova Member Posts: 4
edited 2022-07-15 in NAV Tips & Tricks
How can I concatenate two fields into one?
I have to concatenate Item No. and Variant Code into one field with underscore.
Ex: Item No._Variant Code. 2000_Onesize.

Regards,
Perizat.

Best Answer

  • krikikriki Member, Moderator Posts: 9,094
    Answer ✓
    [Topic moved from 'Navision e-Commerce' forum to 'NAV Tips & Tricks' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Answers

  • SaifB2MSaifB2M Member Posts: 6
    edited 2022-05-18
    Use this :
    YourVariableName := format(YourTableName."Item No.") + '_' + format(YourTableName."Variant Code")
  • krikikriki Member, Moderator Posts: 9,094
    Answer ✓
    [Topic moved from 'Navision e-Commerce' forum to 'NAV Tips & Tricks' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.