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
Read three charecters after decimal
Moderators: chulett, rschirm, roy
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Read three charecters after decimal
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
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.
Re: Read three charecters after decimal
Hi adams06
Can you try something like this:
Can you try something like this:
Code: Select all
If Field(Trim(DSLink.field),'.',2)=xyz then X else ''
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
Hi,
you can try this too..
Thanks,
Anupam
you can try this too..
Code: Select all
if DsLink['.',1,1] = 'xyz' then 'X' else ''
Anupam