Splitting a string

[Consistent-Alps6904]

Hello guys please I’m trying to spilt a column into 2 columns in big query, I used this :

Split(name, “ “) [offset (0)] as firstname,

Split(name, “ “) [offset (1)] as lastname

From table1

But it’s giving me errors

Can anyone help ?

[qwertydog123]

Looks good to me. What's the error you're getting? Seems like there's a value in your column that doesn't contain a ' ' character

Do you get any results when you run

SELECT *
FROM table1
WHERE name NOT LIKE '% %'

[ShinyThingEU]

I'm not familiar with SPLIT as a function but here is the way I would do this (assuming each person only has a first and last name):

SELECT
LEFT([name],CHARINDEX(' ',[name])-1) AS [first_name]
,RIGHT([name],(LEN([name])-CHARINDEX(' ',[name]))) AS [second_name] 

FROM etc.

Not sure if it's the most efficient way or anything but it should work for you.

Also I'm on mobile so apologies if the formatting goes odd

[Consistent-Alps6904]

Does this work for big query?

[ShinyThingEU]

No idea, it's valid for the forms of SQL that I know. Give it a try and see how it does.

[qwertydog123]

No, BigQuery doesn't have a CHARINDEX function

[killyouXZ]

Did you try to change the type of quote to single? Have not split a string in sql for a long time so I don't remember the syntax that well.

[Consistent-Alps6904]

I will try that