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 .

[sunny_talwar]

Have you tried SubField()?

May be this:

SubField(FieldName, ',', 2) as NewFieldName

or

SubField(FieldName, ',', -1) as NewFieldName

[Anonymous]

Sunny, with this expression he will get complete subfield from specified location but as asked by him

and i need the just to retrieve only the char after the ','

I think he need char only, like say

ad,sj2    Here he should get sj onlly instead of sj2

Ahmad, Is it right??

[sunny_talwar]

May be this in that case?

PurgeChar(SubField(FieldName, ',', 2) as NewFieldName, '0123456789') as NewField

[mohsinqlik]

Adding to logic sunny shared

purgechar(SubField(FieldName, ',', 2),1234567890) as NewFieldName

Regards,

Mohsin

[Anonymous]

Good One Sunny

Will this alias work inside the field parameter?

[sunny_talwar]

Thanks man

[sunilkumarqv]

perhaps you can use like this

subfield(PurgeChar(FieldName,'0123456789'), ',',2)  as NewField

[jood_ahmad]

yes

[jood_ahmad · Accepted solution]

Dears,

thank you very much to your replay the closest answer is Sunny

SubField(FieldName, ',', 2) as NewFieldName 

the addition thing is define a variable to count how mane char after the ',' .

thank you all