Solved: Copy data to seperate column, split() string by Sp... - Page 2

logan_juern · 04-10-2019 12:27 PM

Hey there-

I’m trying to maintain column “Location” as is, and create 2 virtual columns.

Right now data auto-populates in Location as “200B 2A”
I’m trying to use the Split() function to separate that into a 200B column and a 2a column without affecting the source column.

Does anyone have any tips?

**Quick Tip: Ensure your new virtual columns are added to your slices.

LeventK

@logan_juern
Provided you have that extra 2 columns in your gSheet back-end, you can below expressions in the AppFormula property of those columns:

IFS(ISNOTBLANK([Location]),INDEX(SPLIT([Location]," "),1))

IFS(ISNOTBLANK([Location]),INDEX(SPLIT([Location]," "),2))

View solution in original post

Copy data to seperate column, split() string by Space?