Seperate coordinates

how do i separate column a into columns b and c like below

column a: coordinates (89.00001111, -93.1110292)

column b: 89.00001111

Column c: 93.1110292

You can use a Split Text to create an array, then two Single Value columns to pull out each part.

You can also use two Javascript columns to split the text and return each part.

1 Like

how do i pull out each part @Jeff_Hager in each column after split?

Single value column > From start

2 Likes

sorry…lol…i never used that column before…I thought he was referring to single text column lol

1 Like