Read three charecters after decimal

[adams06]

Hi,

I have to read the last three charecters after the decimal, how can i do this.

ex: 111-222.xyz
222-333-s2.abc
111-444_c_1.asd

Thanks & Regards

[chulett]

Is there always just one decimal point? Is is alright to take everything after it or just literally the first three characters?

Use the FIELD function to take the second field based on the dot as the delimiter. Substring afterwards to 3 if that's all you need.

[adams06]

Hi,

I need to read the extensions of file.

i am using this code:

if Trim(Field(DSLink.field,'.',2))[1,3] = 'xyz' Then 'X' else ''

Thanks

Is there always just one decimal point? Is is alright to take everything after it or just literally the first three characters?

Use the FIELD function to take the second field based on the dot as the delimiter. Substring afterwards to 3 if that's all you need.

[loveojha2]

You can try

Right (DSLink.field, 3)

if you are sure of every file having an extension 3 character long.

[meena]

Hi adams06
Can you try something like this:

Code: Select all

 
If Field(Trim(DSLink.field),'.',2)=xyz then X else ''

[sb_akarmarkar]

Hi,
you can try this too..

Code: Select all

 if DsLink['.',1,1] = 'xyz' then 'X' else '' 

Thanks,
Anupam