Elwyn Roberts
- Total activity 35
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 5
- Subscriptions 5
Comments
Recent activity by Elwyn Roberts-
Very detailed explanation - thanks. As mentioned, I am using your first solution (formatting to drop the milliseconds) which solves the issue. Thanks to both of you for the follow up and the solu...
-
Here you are. I also included the fix mentioned from Konsta and I did the TIMESTAMP for this as well, just for reference - I guess to show what values are going into TIMESTAMPDIFF that works and w...
-
Currently using Version 11.1.12A ticket wont be necessary as what you suggested did work. But I am confused as to why. The field #Start and #End were already DATE type fields so I used FORMATDATE...
-
OK so I have diagnosed it further and determined it is not a Datameer issue, but an issue with the file being created. The file is being generated automatically from a system called Aspect. The f...
-
Hi Alan - we have done what you suggested, it runs on a schedule at 11.30 so will see if it is successful.Konsta - we have Excel 2013, although the file is generated from a Aspect system I believe ...
-
It is in the Data Details and does have include. As mentioned, if we put space in the first row after the heading, it imports fine. (there are roughly 200K rows, the first row with values is at r...
-
Thanks Alan. Unfortunately it looks like we are not using the same version... I dont have that option available.
-
Ok solved it. It was as suspected a line feed (carriage return)...although I thought the // in the regex was supposed to handle that. When I was testing, I would copy the text into a new workbook...
-
Only works up to 12 characters, so the space after the 311 causes it to fail. I have to assume this is also a special character maybe?
-
OK I have gotten somewhere or maybe a clue....but to answer your questions, no not nesting the functions and the LEFT function was wrapped around the T. So REGEX( LEFT( T( the thinking that, con...