I want to split a string in a column that is separated by space into multiple column is SQL.
I used the query below, but I get NULL values
select
PARSENAME(REPLACE(FX_RAW_DATA, ' ', '.'), 1) AS Country_Code,
PARSENAME(REPLACE(FX_RAW_DATA, ' ', '.'), 2) AS iso_Code,
PARSENAME(REPLACE(FX_RAW_DATA, ' ', '.'), 3) AS status,
PARSENAME(REPLACE(FX_RAW_DATA, ' ', '.'), 5) AS date,
PARSENAME(REPLACE(FX_RAW_DATA, ' ', '.'), 6) AS rate,
PARSENAME(REPLACE(FX_RAW_DATA, ' ', '.'), 7) AS fx
FROM process.FX_RAW_DATA_OUT;
GO
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…