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
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.........
Your error message means.......you have not used the Function properly......... Please check it again.
can you give an example, because I am unable to find $$CaseConvert in Tally Developer under Functions
in Tally Developer ........... Press Ctrl+D ......... type CaseConvert and you will get the search results.
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 ""
Set As : $$CaseConvertroperCase:"hello this is a trial sentence" Set as above and see if it works.......
Not Possible Buddy... Probably Your Syntax is Wrong Correct Syntax $$CaseConvertroperCase:"Hello world"
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
It is working for us......... if not for you........then error lies elsewhere.........maybe in definition of your "MyCusStyle"
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
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?
Yes........make the original Narration Field in Voucher to "ProperCase" or "TitleCase" and rewrite the data.
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
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.......
the fact that it works for us.......and not for you......... then the problem lies elsewhere........ Check images below..........