# Arrayformula for Item SKU
**URL:** https://community.glideapps.com/t/arrayformula-for-item-sku/19467
**Category:** Ask for Help
**Created:** [December 6, 2020, 11:39pm UTC](https://community.glideapps.com/t/arrayformula-for-item-sku/19467 "2020-12-06T23:39:57Z")
**Posts on this page:** 14
**Page:** 1
### Author:  [@Mohamad\_Al\_Sadoon](https://community.glideapps.com/u/Mohamad_Al_Sadoon)
#### Post date: [December 6, 2020, 11:39pm UTC](https://community.glideapps.com/t/arrayformula-for-item-sku/19467/1 "2020-12-06T23:39:57Z")
Hey guys,
I made some explanation in this video I hope you guys can share your thoughts
Thanks in advance!
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [December 7, 2020, 12:08am UTC](https://community.glideapps.com/t/arrayformula-for-item-sku/19467/2 "2020-12-07T00:08:39Z")
Hi Mohamad, great question. I think you should find it easy by using the add row feature, you may need to use a compound action with it or if your using a form just designate the columns accordingly.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 7, 2020, 12:48am UTC](https://community.glideapps.com/t/arrayformula-for-item-sku/19467/3 "2020-12-07T00:48:29Z")
Are you familiar with the SPLIT formula? That combined with an arrayformula will allow you to split the string by the pipe (|) delimiter into separate columns.
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [December 7, 2020, 1:00am UTC](https://community.glideapps.com/t/arrayformula-for-item-sku/19467/4 "2020-12-07T01:00:28Z")
Arrayformulas cannot correctly use the split action. You would need a script instead.
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [December 7, 2020, 1:03am UTC](https://community.glideapps.com/t/arrayformula-for-item-sku/19467/5 "2020-12-07T01:03:11Z")
It would be great if it did work it would look like this:
=ARRAYFORMULA(SPLIT(B2:B,"|")
But it would split the text into the columns directly to the right of column “B”.
And everytime you did this it would remove previous splits in rows above.
A script can take the cell values copy them to the correct location while keeping original data intact and then perform the split on the column the data was added to recently. With doing this you do not risk data be overwritten and it would perform correctly regardless.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 7, 2020, 1:06am UTC](https://community.glideapps.com/t/arrayformula-for-item-sku/19467/6 "2020-12-07T01:06:15Z")
Wouldn’t this be correct?
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [December 7, 2020, 1:06am UTC](https://community.glideapps.com/t/arrayformula-for-item-sku/19467/7 "2020-12-07T01:06:50Z")
Is that the same array function?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 7, 2020, 1:07am UTC](https://community.glideapps.com/t/arrayformula-for-item-sku/19467/8 "2020-12-07T01:07:46Z")
Yes, it’s an arrayformula in cell F2.
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [December 7, 2020, 1:08am UTC](https://community.glideapps.com/t/arrayformula-for-item-sku/19467/9 "2020-12-07T01:08:39Z")
Everytime I have attempted to use that on delimiters other than common delimiters it messes up. But hell, if it works then it works. There you go, paste formula in column T and your done.
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [December 7, 2020, 1:13am UTC](https://community.glideapps.com/t/arrayformula-for-item-sku/19467/10 "2020-12-07T01:13:34Z")
Thin, write the formula using the “|” as the delimiter. whenever I try to use delimiters like that it does not work properly.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 7, 2020, 1:19am UTC](https://community.glideapps.com/t/arrayformula-for-item-sku/19467/11 "2020-12-07T01:19:45Z")
It works here.
```
=ARRAYFORMULA(IF(D2:D<>"",SPLIT(D2:D,"|"),""))
```
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [December 7, 2020, 1:26am UTC](https://community.glideapps.com/t/arrayformula-for-item-sku/19467/12 "2020-12-07T01:26:25Z")
Nice, even after I copied and pasted it over it didn’t work.
I went to change my spreadsheet settings to UK then back to the states and it worked…I don’t know if I was actually on the states…
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 7, 2020, 2:19am UTC](https://community.glideapps.com/t/arrayformula-for-item-sku/19467/13 "2020-12-07T02:19:16Z")
Hmm, that’s weird. I’ve seen semi-colon`(;)` and comma`(,)` swap roles based spreadsheet locale, but I never seen issues with pipe. I’m used to working with pipe delimited data where I work, but I suppose it’s not a common delimiter for most people.
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [December 7, 2020, 3:35am UTC](https://community.glideapps.com/t/arrayformula-for-item-sku/19467/14 "2020-12-07T03:35:25Z")
I actually have a iventory list of vehicles at work that I run a a script same time everyday that does this delimiter process because no matter how many times I attempt to automate it, it doesn’t work. So I just wrote a script using the same function wtih no issues afterwards.