Multi-Value UV Database OCONV and ICONV Formats HomePage
Powered by Webelink.com    
#  Conversion  Internal  External  Type  Description
1. MR2 7092589 70925.89 Decimal
2. MR2, 7092589 70,925.89 Decimal
3. MR2,$ 7092589 $70,925.89 Decimal
4. MR2,$ -7092589 -$70,925.89 Decimal
5. MR2,D$ 7092589 $70,925.89DB Decimal Show Debit Sign for a positive number.
6. MR2,C$ -7092589 $70,925.89CR Decimal Show Credit Sign for a negative number.
7. MR2,E$ -7092589 <$70,925.89> Decimal
8. MR2,$*14 7092589 $****70,925.89 Decimal Pad to 14 characters with an "*"
9. MR0,Z 7092589 7,092,589 Decimal Show 0 decimals with 0 implied decimals.
10. MR02,Z 7092589 70,926 Decimal Show 0 decimals with 2 implied. Notice the rounding.
11. MR20Z 654910 654910.00 Decimal Show 2 decimals with 0 implied, trailing zero.
12. MR20Z 6549.1 6549.10 Decimal Show 2 decimals with 0 implied, trailing zero.
13. MR20,Z 6549.1 6,549.10 Decimal Show 2 decimals with 0 implied, trailing zero.
14. MR2,M -7092589 7,0925.89- Decimal Minus sign as a suffix.
15. MD2, Null Decimal Null internal value shows an external Blank space.
16. MR2, Null 0.00 Decimal Null internal value shows an external "0.00".
#  Conversion  Internal  External  Type  Description
17. D2- 14281 02-05-07 Date mm-dd-yy
18. D4- 14281 02-05-2007 Date mm-dd-yyyy
19. D2/ 14281 02/05/07 Date mm/dd/yy
20. D4/ 14281 02/05/2007 Date mm/dd/yyyy
21. D0 14281 05 FEB Date dd mmm
22. D 14281 05 FEB 2007 Date dd mmm yyyy
23. D- 14281 02-05-2007 Date mm-dd-yyyy
24. D2Y 14281 07 Date yy (2-digit year)
25. DJ 14281 36 Date Julian Date (1-365), Ordinal Day of Year
26. DY 14281 2007 Date yyyy (4-digit year)
27. DD 14281 05 Date dd (numeric day of month)
28. DW 14281 1 Date n (numeric day of week) Monday=1, Sunday=7
29. DOW 14281 1 Date n (numeric day of week) Monday=1, Sunday=7
30. DM 14281 2 Date mm (numeric month of year)
31. DMY 14281 2 2007 Date mm (numeric month of year) yyyy (4-digit year)
32. DQ 14281 1 Date n (numeric quarter#)
33. DMA 14281 FEBRUARY Date xxx (alphabetic month name), A = alphabetic form
34. DMB 14281 FEB Date xxx (alphabetic month name), B = abbreviated form
35. DWA 14281 MONDAY Date xxx (alphabetic day name)
36. DWB 14281 MON Date xxx (alphabetic day name), B = abbreviated form
#  Conversion  Internal  External  Type  Description
37. MCU George Washington GEORGE WASHINGTON Text Convert all lower case letters to upper case.
38. MCL George Washington george washington Text Convert all upper case letters to lower case.
39. MCT george washington George Washington Text Convert all to lower case starting with the 2nd character.
40. MCP ….. Text Convert all non printable characters to periods.
41. MCA George6800 George Text Retrieve all alphabetic characters from the string.
42. MCN George6800 6800 Text Retrieve all numeric data from the string
#  Conversion  Internal  External  Type  Description
43. MCDX 8438015 80C0FF Hex Convert a decimal number to the hexadecimal equivalent.
44. MCXD 80C0FF 8438015 Hex Convert a hexadecimal number to the decimal equivalent.
#  Conversion  Internal  External  Type  Description
45. G*1 pick*is*a*quick*dbms pick Group Group Extraction using the delimiter of "*"
46. G1*1 pick*is*a*quick*dbms is Group Group Extraction using the delimiter of "*"
47. G1*2 pick*is*a*quick*dbms is*a Group Group Extraction using the delimiter of "*"
48. G1*3 pick*is*a*quick*dbms is*a*quick Group Group Extraction using the delimiter of "*"
49. G2*1 pick*is*a*quick*dbms a Group Group Extraction using the delimiter of "*"
50. G4*1 pick*is*a*quick*dbms dbms Group Group Extraction using the delimiter of "*"
#  Conversion  Internal  External  Type  Description
51. MT 7200 02:00 Time hh:mm
52. MT 54000 15:00 Time hh:mm
53. MTH 54000 03:00pm Time hh:mm {am,pm}
54. MTS 7200 02:00:00 Time hh:mm:ss
55. MTH 7200 02:00am Time hh:mm {am,pm}
56. MTHS 7200 02:00:00am Time hh:mm {am,pm}
57. MT. 54700 15.11 Time hh.mm (use the command INT(OCONV,'54700','MT.')) to round down to the last hour)
#  Conversion  Internal  External  Type  Description
58. U50BB 0309 apl.files User Exit who = oconv('','U50BB'), who from BASIC returns port# and acccount
 © Copyright 2003-2010 webelink.com. All Rights Reserved.   | Click to Email for Info | Terms of Use |