Hello, I'm trying to figure out how I might be able to extract a portion of string relative to the position of a delimiter or other character.For example, I have a table of Events that are structured as follows:##### | <Name of Event>.I want to be ab...
After through the documentation on DATETIME_PARSE() I’m not seeing the timezone respected when used in conjunction with either SET_LOCALE() or SET_TIMEZONE() for conversion of a string field containing date and time information. What am I missing her...
I have table where I’m tracking attendance versus enrollment of a training workshop. I’m using a name field that also has a lookup field displaying whether someone goes by a formal name or an alias. I have another field that has an array of all atten...
I have a Learning Course table that tracks courses with either a single session or dual sessions via checkbox fields. I have links to fields in this table that identify whether an enrollee has completed the relevant sessions(s). From there I have a c...
I’m have some datetime fields that I’m trying to format down to isolate the time. However, I’m seeing that there are some glitches with how the time renders based on time zone. My source datetime field is formatted to PDT, but the output appears to b...
Thanks for your reply @bruceconsulting . In the meantime since I posted, I ended up creating a version of one of your suggestions, using the FIND() command since there is variability in the number of characters preceding and following the vertical ba...
Hi @Kamille_Parks , the REGEX worked! Thanks for that! What I had meant before of having “no effect” was that the CONCATENATE operator, “&,” didn’t produce any different results. I appreciate your time!
Thanks for your reply @Kamille_Parks. Unfortunately, this has no effect. I need to FIND either one or the other strings (Alias, or Name) within the Workshop Session Attendance field (which is an array of multiple linked records). Do you have any othe...