You’re offline. This is a read only version of the page.
20
Greetings Community -
I found an online blog (don't remember the URL) which helped me get the function below to convert DateTime format to UNIX Format.
The output of the below function is accurate, however, when I get the Decimal as a return value of the function and try to convert it to text, the additional spaces show up between the digits, strangely enough
After trying DELSTR(String,'='), the spaces don't go away. I am probably missing something, can anyone please assist?
The Format command includes all signs by default. In your case the thousand delimiter is probably a space.
The best option is to use an extra parameter to indicate how the decimal should be formatted. The standard XML format will work here:
Format(UnixDecimal, 0, 9);
Then you don't need to remove any character afterward.
Hi Daniel - Thanks for the suggestion. I tried both these formats of DELCHR, but it does not seem to work, same output. Moreover, when I try to find the position/occurrence of a blank character in the string using STRPOS, it gives me a 0 (no blank substrings exist)
I then tried converting my string output into ASCII, and there are ASCII Blank spaces in between. I am really confused as to what is happening
Do you know what is happening?
String Pasted from the Debugger: 1 674 610 728 407
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,134
Super User 2024 Season 2
#2
Martin Dráb
229,928
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (