divide fields?

  • Thread starter Thread starter Alejandra Parra
  • Start date Start date
A

Alejandra Parra

How can I divide a field that looks like this
Column
data1/data2
data3/data4
d5/d6

So I can have after the query
Column1 Column2
data1 data2
data3 data4
d5 d6
 
Permanently or temporarily? Temporary solution

SELECT OriginalColumn,
Left(OriginalColumn,Instr(1,OriginalColumn,"/")-1) as Col1,
Mid(OriginalColumn,Instr(1,OriginalColumn,"/")+1) as Col2
FROM YourTable

Permanent
UPDate YourTable
Set Col1 = Left(OriginalColumn,Instr(1,OriginalColumn,"/")-1)
Col2 = Mid(OriginalColumn,Instr(1,OriginalColumn,"/")+1) as Col2
FROM YourTable
WHERE OriginalColumn like "*/*"
 
Alejandra,

If you are guaranteed to have a "/" in the column, then it is relatively
easy

SELECT LEFT([yourColumn], INSTR([yourColumn], "/") -1) as Column1,
MID([yourColumn], INSTR([yourColumn], "/") +1) as Column2
FROM yourTable

It becomes a bit more difficult if you are not guaranteed to have the "/"

HTH
Dale
 
Back
Top