Options

Format CODE to TEXT

Sergey_R.Sergey_R. Member Posts: 6
Hi all!I need to format variable from CODE to TEXT and pass it to the external program via
SHELL(STRSUBSTNO ....
.I use string
=FORMAT(ae."Cross-Reference No.")
,taking from help:"default format code to text",but in vain..What i supposed to do with this?How to format code to text properly?

Comments

  • Options
    Sergey_R.Sergey_R. Member Posts: 6
    Nobody nows an answer?
    I do need help in this field..Cause I've tried everything.. ](*,) ](*,) ](*,)
  • Options
    EvertPrinsEvertPrins Member Posts: 6
    Why should you convert it?
    A Code and a text variable are almost treated the same in Navision.
    The only difference is that a code field is always in uppercase.

    You can 'convert' a text to code and vica versa without a Navision function

    So:

    TextVariable := CodeVariable

    Or:

    CodeVariable := TextVariable


    Or in your case something like this:

    SHELL(STRSUBSTNO('%1',ae."Cross-Reference No."));
  • Options
    kinekine Member Posts: 12,562
    Out of my office for two days... :-)

    You are using FORMAT coprrectly... there must be error somewhere else...

    text := FORMAT(code); is correct....

    PLease, send part o the code or more info...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    Sergey_R.Sergey_R. Member Posts: 6
    I've got it!
    I've solved my problem.I should read more FAQ's and manuals and I did so.Anyway,thnx for help!
Sign In or Register to comment.