How to Trim a value

[#1]

Hi,

    I Have id value like "0123458....." i want this value "0123458"how to trim this "........." value.

[sunilkumarqv]

Copy and past this in your script

=PurgeChar( '0123458.....',.) it returs 0123458

[preminqlik]

replace(fieldname,'.',null())                    as               Newfieldname

[ThornOfCrowns]

That's a lot of ways to do the same thing! I personally like the KeepChar function.

[#5]

Thanks to all, I have one more file like,

RT25698-R

ED56248-R

GR78542-S

How to remove the -R and -S value,Please give query.

[ThornOfCrowns]

=Left(FieldName,7) if your values are all the same length.

[preminqlik]

here u can use subfield(fieldname,'-',1)

[robert99]

or if not the same length

left (fieldname,index(fieldname,'-')-1) should work