Get values from a DOT,comma separated value in SQL

Get first or second values from a DOT, comma separated value in SQL

DOT
-----
select cast(left(FiledName,CHARINDEX('.',FiledName)-1) AS INT)FirstValue
FROM    TableName1 where [Id]=193012

comma 

 
select cast(left(FiledName,CHARINDEX(',',FiledName)-1) AS INT)FirstValue
FROM    TableName1 where [Id]=193012