× Discuss on T24 Installation, Setting up the environment, TC Server, jBOSS, Package & Deployment, etc…

How we use TRIM function on enquiry

  • mrul3s
  • Topic Author
  • Visitor
  • Visitor
10 years 5 months ago #16743 by mrul3s
How we use TRIM function on enquiry was created by mrul3s
ho we use TRIM function on enquiry
Column displays data like this but PKR is not my requirement.
PKR1705901.48
PKR1785123.84
PKR58455.12

my requirement is only Numeric
i,e
1705901.48
1785123.84
58455.12

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

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • retired . . . ¯\_(ツ)_/¯
More
10 years 5 months ago #16746 by jpb
Replied by jpb on topic How we use TRIM function on enquiry
You can use

CONVERSION : EXTRACT 4,99
The following user(s) said Thank You: mrul3s

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

  • mrul3s
  • Topic Author
  • Visitor
  • Visitor
10 years 5 months ago #16748 by mrul3s
Replied by mrul3s on topic How we use TRIM function on enquiry
Thank you

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

Time to create page: 0.035 seconds