DSXchange

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

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.

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

chulett wrote: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.

You can try

Right (DSLink.field, 3)

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

Hi adams06
Can you try something like this:

Hi,
you can try this too..
Thanks,
Anupam