Slice & Splice

Explore

Gallery

Slice & Splice

⁠
⁠
⁠

Formulas: Slice() and Splice()

Category: Collections

⁠

Slice()

Extracts a selected portion of a list

or stated otherwise...

Hey Coda, here’s a list for you. Now, I want you to slice out only part of the list, starting here and ending here.

⁠

Splice()

Removes and adds values to a list

put a bit simpler...

Hey Coda, Im going to give you a list, but I want to change it a bit. Sometimes I want to add values, and sometimes delete them. Oh! Can I also specify where in that list I want you to do that?

Slice() and Splice() share some parameters while also having some of their own. For simplicity, we will look at each formula’s parameters separately.

Slice() has three parameters:

⁠

Value

Slice(Value, Start, End)

A piece of text or list of values.

⁠

Start

Slice(Value, Start, End)

Position in list you want to start from.

⁠

End

Slice(Value, Start, End)

Position in list at which you want to end.

Splice() has four parameters:

⁠

Value

Splice(Value, Start, DeleteCount, InsertValue)

A piece of text or a list of values.

⁠

Start

Splice(Value, Start, DeleteCount, InsertValue)

Position in list you want to start from.

⁠

DeleteCount

Splice(Value, Start, DeleteCount, InsertValue)

The number of items you want to delete.

⁠

InsertValue

Splice(Value, Start, DeleteCount, InsertValue)

Values, text, list you want to insert.

⁠

Slice

Slice() takes a list and allows you to get a smaller portion of that list. Just like a pizza slice is a smaller section of a whole!

List of 21 Countries:

⁠

South KoreaKuwaitCayman IslandsKazakhstanLaosLebanonSaint LuciaLiechtensteinSri LankaLiberiaLesothoLithuaniaLuxembourgLatviaLibyaMoroccoMonacoMoldovaMontenegroMadagascarMarshall Islands

⁠

Use the sliders below to return a sliced portion of the list.

Give me a sliced list starting from this position:

⁠

Give me back a total list of countries this large:

⁠

LesothoLithuaniaLuxembourgLatviaLibya

⁠

Tables are also lists! Watch how you can choose how many plants you would like to see from our

Plants Database⁠

below

Show me the first

⁠

plants from the database

Poison Oak

Pacific Trillium

Lemon Balm

Deer Fern

⁠

Splice

Only one letter away from Slice(), but the P makes a world of difference. Splice() allows you to manipulate lists by...

Inserting new values into a list.

Optionally deleting values from a list.

Try modifying the list of 11 words below by inserting a word of your choice and deleting any number of items as well:

I want to insert the word:

⁠

I want to place it in this position:

⁠

I also want to delete this amount of items after that:

⁠

Modify my list!

⁠

Original List

Modified List

tacomenucatcodaburritocomputerdatabaselistkeymusiccoffee

There are no rows in this table

⁠

Practice: Use Slice() to grab the first three rows from a table

Done

Filter a table so it only shows rows with the largest number of votes

Done

Challenge: Create a Spoonerism for names

Done

⁠

Ready to master Coda yourself?

⁠

Coda School Take your Coda formulas from "I can get by" to "I can do anything" with a fully interactive course designed to be taken at your own pace, with accountability and community built in. www.codaschool.io⁠

Gallery

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.

Slice & Splice

⁠⁠⁠

Slice

Splice

Ready to master Coda yourself?

⁠
⁠
⁠