Hi,
I am using a following syntax to repalce comma character and then if I find any "!" in my string I want to set it to NULL to avoid using those values.
However I still see output column values with comma in it.
var1 = Convert("#$%/&,;","!!!!!!!", SvDomain)
and using a following constraint to set it to null Index(var1, "!",1) >0
thank you,
Kiran
convert function to strip out comma character
Moderators: chulett, rschirm, roy
convert function to strip out comma character
Regards
Kiran
Kiran
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
resovled by giving length filed to Stg var. substring
I did not gave value for length filed while calculating SvDomain Stg. variable using substring function.
issue is resolved as soon as i provide length in substring.
I saw only records related to "comma" made me to post this topic.
Anyway thank you All!!!
Kiran
issue is resolved as soon as i provide length in substring.
I saw only records related to "comma" made me to post this topic.
Anyway thank you All!!!
Kiran
Regards
Kiran
Kiran