General discussion
Missing Emails
Forums
Hello everyone. If anyone sent emails to me or were wondering why they were not receiving notices in the last week or so one of the sites on this server was hacked and used to send out spam emails so this site was blacklisted and emails were rejected by yahoo and other email companies. The problem has been fixed and my host says that all emails should be going through but anything during that period would have been lost.
Thanks
Brian
- Read more about Missing Emails
- Log in or register to post comments
Delete ODBC connections
Forums
Hi,
trying to configurate a ODBC connection I have created lots of them and now, I don't know how to delete them from the ODBC import list. Can anyone help me, please?
Thanks!
- Read more about Delete ODBC connections
- 2 comments
- Log in or register to post comments
Between
Forums
Hi,
I would like to find an equation that allow me to find a number if it is in a range of numbering
I attachd a file .xls as un example,
Thank you.
- Read more about Between
- 9 comments
- Log in or register to post comments
Function to Round
Forums
Hi All,
I have column of duration in second and i need to round it : first to 60 and to 30 by creating two column.
Using @Round isn't very helpful for me, so ; is there any function ? or should i use @Round with another function,
Thank you.
- Read more about Function to Round
- 4 comments
- Log in or register to post comments
Get percentage
Forums
Hi,
I need to do a calcul to get a result in percentage % , so is there any function or script to do it ?
as alternative solution what I'm doing is : creating new numeric field and I insert this fomule : (Column A / Column B )*100
Thank you.
- Read more about Get percentage
- 6 comments
- Log in or register to post comments
comparison between lines
Forums
Hi;
I've a database that I need to compare between the line 1 and the line 2 ...e,
for example :
In this case; i need to get the difference between the start call of line 2 with the end call of line 1 and
Thank you.
START CALL
DURATION
Duration_HOURS
End_Call
17:26:18
139
00:02:19
17:28:37
17:28:50
60
00:01:00
17:29:50
17:29:52
45
00:00:45
17:30:37
- Read more about comparison between lines
- 4 comments
- Log in or register to post comments
Formatting Collums, for Appending purpose
Forums
Hello everybody,
I am having difficulty in appending multiple sheets importing from excel. Why i tried to join these sheet together, the system notify me about the field format is different. Is there a way or any tips to mass formatting multiples sheets at one? Since having 50+ sheets to append might be time consuming.
Thank you very much,
Best regards,
Trung Nguyen
- Read more about Formatting Collums, for Appending purpose
- 4 comments
- Log in or register to post comments
Calculate the Duration in seconds
Forums
Hi All,
I need to deal with a field ( numeric type) containing a number called duration with this format for example : 14100 wich mean that the duration is 101 second, another exmaple :
1333800 = 5618 second
1410100=6061 second
So which function ca help me to get the result in second ?
Thank you.
- Read more about Calculate the Duration in seconds
- 5 comments
- Log in or register to post comments
Extract without duplicated data
Forums
Hi All,
Can you help or guid me to extract without duplicated data ?
column A (character type ):
1
2
1
4
5
1
3
Thanks.
- Read more about Extract without duplicated data
- 7 comments
- Log in or register to post comments
Function or Script
Forums
Hi All,
I have a field that contains a list of number separated by (,), what i need is : create a lot of field depended of how number contained in it ,
for ex : 3554249, 3554250, 3554251, 3554252 and the result that i'd like is for ex :
A
B
C
D
3554249
3554250
3554251
3554252
Thank you.
- Read more about Function or Script
- 24 comments
- Log in or register to post comments