How to use the SPLIT function in Google Spreadsheets with different delimiters and with some delimiters with multiple characters?

My question is similar to this one: SPLIT function in Google Spreadsheets with OR statement

but has the following difference:

I want to use the delimiter “apple” and the delimiter “.” within the SPLIT function.

Since the delimiter apple has multiple characters, @parkydr answer here doesn’t work.


On this input on A2:

I ate an apple on the bus home. Going 

I want it to split like this:

I ate an / on the bus home / Going 

I tried this:

=SPLIT(A2,"apple.",TRUE)  I / t   /   n   / on / th   / bus / hom / Going 

and this

=SPLIT(A2,"'apple''.'",TRUE)  I / t   /   n   / on / th   / bus / hom / Going 

and this

=SPLIT(A2,"apple.",false)  I ate an apple on the bus home. Going 

and this

=SPLIT(A2,"apple"".",false) #ERROR Formula parse error. 

and this

=SPLIT(A2,"'apple''.'",false) I ate an apple on the bus home. Going 

How to make return the next split?

I ate an / on the bus home / Going 

Thanks a lot for your help!

Combine text from multiple cells into a single cell with multiple mixed delimiters

Does anyone know a formula to combine several cells into a text in one cell with mixed delimiters between words?

Cell A1 – First Name
Cell B1 – Last Name
Cell C1 – Job Title
Cell D1 – Company

I would like to combine the first two cells with a space and the rest with a comma followed by a space. My target for the above cells is:

“First Name Last Name, Job Title, Company”

Does anyone know a formula for this please?

Joining two rows of data with alternating delimiters

I’m working with two rows of values that are related to each other and trying to build a formula that will compile the data into one cell, with syntax that uses two delimiters.

If a cell in the active row contains a value, I want to pull the information in row 2 and 3, pair them together with delimiter |, and then use another delimiter ; until all of the values have been added. The output should end up as:


I’ve attempted textjoin, join, and ifs functions, but I can’t find the right way to structure a formula to accomplish this because I’m not aware of a way to make the argument alternate the values in two rows until the end of the data. I’ve tried nesting another textjoin but this only appends the values/delimiters rather than alternating them.

Any suggestions on how I could structure this would be appreciated.

Help with awk on how to extract with multiple delimiters

I have below lines I need to extract below data

[97257]{-1}[-1/-1] 2018-12-20 00:25:05.913293 e cs_ddl DropTable.cpp(00030) : cannot get table
[145208]{-1}[-1/-1] 2018-12-20 00:26:46.038752 e cs_ddl DropTable.cpp(00030) : cannot get table for TURBO [52120]{-1}[-1/-1] 2018-12-20 00:28:28.887636 i Logger PlanExecutor.cpp(02746) : Execute plan with next version:

awk -F “:” ‘{print $ 3}’ a1.trc |awk ‘{print $ NF}’|awk -F'(‘ ‘{print $ 1}’|sort |uniq -c 2 DropTable.cpp 1 PlanExecutor.cpp

i know with awk we can use multiple delimitors using reg. exp but not able to get it in easy way.

tried this way – cat a1.trc | awk -F”[.| | ]” ‘{print $ 16}’ but not getting what i need.

All i need is the below output.

   2 DropTable.cpp   1 PlanExecutor.cpp 

Website stopped working – bad flag delimiters error

I’ve had a website that has worked for a year. I changed the domain name, and the hosting company copied all of the data to the new hosting account. The website worked for a few days. Now, with no changes made, I’ve got a 500 Internal Server Error.

The error log says: /home/website/public_html/.htaccess: RewriteRule: bad flag delimiters

The .htaccess file in the public_html folder says:

RewriteEngine on
RewriteCond %{HTTP_HOST} ^(www.)?$
RewriteCond %{REQUEST_URI} !^/cmsfolder/
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ /cmsfolder/$ 1
RewriteCond %{HTTP_HOST} ^(www.)?$
RewriteRule ^(/)?$ cmsfolder/index.php [L]Options +Indexes
Options +Indexes
IndexOptions -FancyIndexing

I haven’t changed anything, so I am not sure why the website would just switch to a 500 server error.

To be honest, I have no idea what I am doing with it and the hosting company does not seem to know either.