text after char

[jood_ahmad]

Dears,

how can i get the text after specific char like if i have :

ad,sj2

0,2

0,10

jak,kavin

and i need the just to retrieve only the char after the ','  i try the right but i cant apply it in all cases some time i did not get the right data

any idea about this .

[Mark_Little]

Hi,

I would read that they only wants the first character after the comma or , char.

So something like

LEFT(SUBFIELD(FieldName,',',2),1) AS NewField

Mark

[kkkumar82]

Hope this may help you  Len(SubField(F1, ',',2))  Thanks Kiran