Narration to Proper Case

Discussion in 'Tally Developer' started by Zaxx, Nov 5, 2020.

    
  1. Zaxx

    Zaxx New Member


    Hello,

    I am using Column Day Book, I need narration to be in Proper Case like this "For The Month November 2020". Now I tried the following code but it didn't worked.

    Code:
    [Field : MyNarration]
    Use : Name Field
    Set As : $Narration
    Border : All Border
    Alter : Voucher
    Style : MyCusStyle
    Case: First Upper Case
    Any help would be appreciated, thanks
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You can do it in this ways........

    [Field : MyNarration]
    Use : Name Field
    Use : First Upper Case Field (will work if this is a data entry field)
    Set As : $Narration
    Border : All Border
    Alter : Voucher
    Style : MyCusStyle

    However, if the above Field is in a report and not a Field where DATA is being entered, then you will have to use $$CaseConvert function.........
     


  3. Zaxx

    Zaxx New Member


    It is in a report, I tried using $$CaseConvert, but it throws an error "Function not defined"
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Your error message means.......you have not used the Function properly......... Please check it again.
     


  5. Zaxx

    Zaxx New Member


    can you give an example, because I am unable to find $$CaseConvert in Tally Developer under Functions
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    in Tally Developer ...........
    Press Ctrl+D ......... type CaseConvert and you will get the search results.
     


  7. Zaxx

    Zaxx New Member


    the code I used was

    Code:
    [Field : MyVoucherType]
    Use : Name Field
    Set As : $$CaseConvert:ProperCase:$Narration
    Border : All Border
    Alter : Voucher
    Style : MyCusStyle

    Can you tell me in which file to search, because I got "Found:"(985)" matches for "CaseConvert ""
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Set As : $$CaseConvert:properCase:"hello this is a trial sentence"

    Set as above and see if it works.......
     


  9. Zaxx

    Zaxx New Member


    Same error, "Could not find description"
     


  10. Himanshu-2002

    Himanshu-2002 Active Member


    Not Possible Buddy... Probably Your Syntax is Wrong

    Correct Syntax
    $$CaseConvert:properCase:"Hello world"
     


  11. Himanshu-2002

    Himanshu-2002 Active Member


    Don't leave space between ProperCase
     


  12. Zaxx

    Zaxx New Member


    Even I am surprised, this is the exact code I am using

    Code:
    [Field : MyVoucherType]
    Use : NAme Field
    Set As : $$CaseConvert:ProperCase:"hello this is a trial sentence"
    Border : All Border
    Alter : Voucher
    Style : MyCusStyle
    I am using this under Report - Form of Column Day Book
     


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    It is working for us.........

    if not for you........then error lies elsewhere.........maybe in definition of your "MyCusStyle"
     


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Also you can try this method..........

    [System : Formula]
    mytext : "hello this is a trial sentence"

    then in Set as .........use @@mytext with the Caseconvert function
     


  15. Zaxx

    Zaxx New Member


    I tried removing "MyCusStyle" and also adding the above mentioned but the error is same.

    $$Upper:"hello this is a trial sentence" is working properly. Is it possible to define $$CaseConvert again in my TDL?
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Try this...........

    $$CaseConvert:TitleCase:$Narration
     


  17. Himanshu-2002

    Himanshu-2002 Active Member


    Uninstall Tally and Reinstall it again....It will work
     


  18. Zaxx

    Zaxx New Member


    is there any other function except $$CaseConvert to convert it to Proper Case?
     


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Yes........make the original Narration Field in Voucher to "ProperCase" or "TitleCase" and rewrite the data.
     


  20. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Take backups and then work on it...............simple.
     


  21. Zaxx

    Zaxx New Member


    I don't want to change the previous data, I just want the new data to be in Proper case. Will this work if I add it in my TDL:

    [#Field : VCH Narration]
    Use : First Upper Case Field
     


  22. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Can't comment .... coz I am not trying on my data, as it is not my requirement.

    You can try on your backup data and see if it works or not.......
     


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    the fact that it works for us.......and not for you.........
    then the problem lies elsewhere........

    Check images below..........

    Capture.PNG

    Capture2.PNG
     


  24. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    This is a sample...w/o CaseConvert........

    Capture3.PNG
     


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    BTW..... are you using a "pirated" version of Tally ??? or an older version ???
     


Share This Page