python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - substitution

How to move multiple lines in a google sheet onto just 1 based on the date?

I have many rows with data like below. I would like to end up with rows that have a single date in one column and the next column contains concatenated info of the other rows, like so: 1/20/2022 Tel...
test-img

JP Douma

split

pivot

google-sheets-formula

substitution

flatten

Votes: 0

Answers: 1

Latest Answer

try: =ARRAYFORMULA(SPLIT(SUBSTITUTE(TRIM(FLATTEN(QUERY(QUERY(A2:B; "select max(B) where B is not null group by B pivot A");;9^9))); " "; "×"; 1); "×"))
test-img

player0

How to Fix an Incorrect Jinja Substitution

Sometimes when using jinja substitution into a preset, the characters are not properly encoded and are left as UTF-8 values, for example: My dynamic preset data contains this field: "src": &...
test-img

Richard Kennedy

jinja2

substitution

Votes: 0

Answers: 1

Latest Answer

To address this issue, you need to use the jinja filter 'replace.' This will override the encoding step and put what you want to the rendered preset. In the above example use this jinja substitution ...
test-img

Richard Kennedy

How to substitute blanks between certain patterns using regex

I want to substitute the blanks between the $# and the ending #. Test String: This is my variable A $#testpattern 1# and this is variable B $#testpattern 2 with multiple blanks# Expected result: This...
test-img

Johannes_FS

java

regex

substitution

Votes: 0

Answers: 2

Latest Answer

Java supports a finite quantifier in a lookbehind assertion, so you can add optional word characters or spaces to it [\w\s]{0,100} and for the lookahead you can add only [\w\s]* matching 1 or more whi...
test-img

The fourth bird

Google Sheets QUERY + SUBSTITUTE to convert dot to coma

Here is my Google Sheets : My datas I would like to import "QUERY" column M,N,O,P,Q,R into another tab (same sheet) but convert dot "." to coma "," from column Q and R. I...
test-img

Tony

arrays

google-sheets

number-formatting

substitution

google-query-language

Votes: 0

Answers: 2

Latest Answer

Try =query({Hoopzi_FlatFileAllOrdersReportbyLastUpdate!M2:P\arrayformula(1*substitute(Hoopzi_FlatFileAllOrdersReportbyLastUpdate!Q2:R;".";","))};"select *")
test-img

Mike Steelson

Posts

Questions

Blogs

Jobs