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-
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...
-
So yes I did that and it does work. The regex did return the right value. Which means I went back to the original workbook, and wondered if it was something wrong with the column values itself so ...
-
Sadly no.... I even tried just taking the first 20 characters with the LEFT function, where I know the the code #Start appears in the first 20 characters of the string but it still did not return a...
-
Hmmm - No error, just an empty string....
-
Didnt work for me. For example, this is the string value#IMPACT-2 #EFFORT-2 #SD-20210407 #BFY #CD-20210421I tried the following code:REGEX(#Notes;".*#SD-([^#]+).*"; "$1")Not sure if I am missing s...
-
Thanks I will give it a go and let you know
-
Version 11.1.3.1No there is nothing that determines the end of the string other than the possibility of the next #
-
Perfect - thanks so much. Funnily enough in my very first attempts to figure this out I did include the milliseconds, but unbeknownst to me the HH was causing an issue too.Great work, thank you so...
-
Hi Alan, Unfortunately I tried that in the past and the "a" doesnt seem to work. See screenshot attached. MODIFIED_DT is a STRING datatype. MODIFIED_DT1 has the formula as shown.
-
Thanks Alan. I went with the import/drop record solution since I wouldn't be able to use/join on non-numeric regardless.