Skip to main content
Stack Overflow
  1. About
  3. For Teams
Filter by
Sorted by
Tagged with
0 votes
0 answers
17 views

I'm genuinely sorry for posting again, I was getting on so well reading and experimenting however this quirk between Instr and InstrRev has me stumped. My string which was a web copy and paste and for ...
Jompra's user avatar
  • 3
-1 votes
3 answers
153 views

I am trying to split a string in SQLite into 4 separate integers. I found online someone doing it with 3 but i am needing 4. I have tried to make comments as I have gone to figure out what each part ...
hle00001's user avatar
0 votes
2 answers
68 views

I have an Excel (VBA) test sub that first searches for named ranges that have the word "Date" in them. Then it's supposed to search through the found named range for all cells in column (2) ...
0 votes
1 answer
117 views

I am trying to create what I expect from the subroutine (GetAllPosition). I don't know where to use RsultOfPostionAndLength in the code to get the expected output My expectation of the output for (...
1 vote
0 answers
128 views

I have a column that contains contact information for businesses that has wrap text on and has 5-8 lines of text in some cells. I need to change the row height based on how much information a cell ...
Hank's user avatar
  • 33
0 votes
0 answers
61 views

I have the following SQL which calculates the length between a start position and end position and then tries to use the start position and length to extract the substring but the substring function ...
-1 votes
2 answers
60 views

Im in construction trying write something to track material inventory from vendors based on material type and moving that quantity from one sheet to another. The problem is that the material name is ...
ZGarcia's user avatar
0 votes
1 answer
109 views

I have code that for the most part is working as intended. However, it is returning one character too many at the end. I tried adding -1 and I get an out of bounds error. What am I doing wrong? SELECT ...
Joe's user avatar
  • 1
0 votes
3 answers
256 views

I have cells with a concatenated list of words (with textjoin) and I want to colorate words differently to make it more readable. Just an example to better explain my problem: 5 Apples / 2 Oranges / 3 ...
0 votes
2 answers
929 views

I am trying to extract the values in a string before the last ~ and first ~ using Snowflake For example: ‘jjjjj~hhhhh-iiiiii~jklmn~abc’ ‘ftgftr~hhhhhiiiiii~jklmn~trf’ ‘fgfgf~hhhhhiiiiii~fgfgf~tddrf’ ...
0 votes
0 answers
77 views

This is a snapshot of the xml in question XML Layout The column I need lies between and , but this lies inside an xmltype column called Flexfiltervalue. How do I write the sql to extract that value ...
0 votes
2 answers
67 views

i am trying to fetch some text from HTML string from a table. the text are like this and i am trying to get the output ID,TEXT 1,<font face="Microsoft Sans Serif" size="8" color=...
0 votes
2 answers
485 views

Currently able to do a VBA search on a column range like H:H and apply conditional formatting if any cells in H:H has a partial match against cell A1, which might be "LTD". However, i'm ...
1 vote
1 answer
41 views

I have following string which is a comma separated list Dim str1, str2 str1="C_adminToolsChartsOnFormsManager,C_adminToolsFormDesignerCopyFormDesign,C_adminToolsManageLocationsAccessSubSystem,...
0 votes
0 answers
91 views

I'm trying to make a macro that will go through a list of emails and flag potential problems by changing their color. I was trying to do it by using the Like function, but I forgot that it's case ...

15 30 50 per page
1
2 3 4 5
...
7

AltStyle によって変換されたページ (->オリジナル) /