Remove some elements from cell

[Giovanni_Sades]

I have a cell containing some elements (“Andy”, “Bill”, “Connor”, “Don”, “Edward”, “Frances”) in column 1.
I also have a cell with some numeric values (4, 2) in column 2.

The numbers in column 2 represent the position of the elements in column 1 to be removed (“Don”, "Bill)

Te desired result would be the elements in column 1 without those in column 2 (“Andy”, “Connor”, “Edward”, “Frances”)

How can I do that?

[Piet_Strydom]

HI Giovanni<

I am a little pressed for time, but the following link should be able to help you.

Button to Modify Rows, Split First and Last Name

Hi there! Totally new to Coda… apologies if this has been asked before (I looked and could not find anything ) I have a table of contacts. My client wants to be able to load in a CSV. The CSV has the First and Last name in one field, and my contacts table does not. I built a table view “Import New Students” to allow for him to copy and paste the CSV, and added two formula fields that split the first and last name up: [First Name (Import)] and [Last Name (Import)]. I want to finish it…

Regards
Rambling Pete

[Christiaan_Huizer]

hi @Giovanni_Sades

one way to approach this you find below:

and this subset from step 01 you FormulaMap in step 02

Hope it helps to find your way, Christiaan

[Giovanni_Sades]

Thanks a lot, Christiaan. I really liked your solution and it works nicely.
I appreciate the time you took to take a look and reply.

[Giovanni_Sades]

Thanks, Piet. I’ll check this out.