× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

Comma Separators

Start
Prev
1
Next
End

ORLY01
Topic Author
Offline
Junior Member

5 years 11 months ago #22263 by ORLY01

Comma Separators was created by ORLY01

How can i add comma separator to an amounts (in enquiry)?
For example, instead of presenting 1192.3 i would like to present 1,1192.3

Please Log in or Create an account to join the conversation.

VK
Offline
Platinum Member
Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test

5 years 11 months ago #22264 by VK

Replied by VK on topic Comma Separators

Hi
use a conversion routine with FMT() applied to O.DATA. See an example in jQL:

LIST F.SPF EVAL "FMT('123456789', 'R2,#15')"

Cheers
VK

Please Log in or Create an account to join the conversation.

ORLY01
Topic Author
Offline
Junior Member

5 years 11 months ago #22266 by ORLY01

Replied by ORLY01 on topic Comma Separators

Thanks!
I actually used CCY CCY in the Type field and it worked

The following user(s) said Thank You: VK

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Time to create page: 0.026 seconds