hi all,
one of my column values containin hyphen(-) in it.
for ex the input seems like 1200-12,563467-093,3789652-02.
In this scenario am in need of the value before the hyphen only and meanwhile the number of digits before the hyphen will greatly vary.Can any one help me to how to get the required value?
Thanks in advance,
veera.
Regarding content validation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Field(InLink.TheString, "-", 1, 1)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Regarding contant validation
hi am having policy_no a a column. In this column only am havin hyphens. could u pls explain in detail how to implement it..ray.wurlod wrote:...Code: Select all
Field(InLink.TheString, "-", 1, 1)
Thanks in advance.......
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Field(InLink.policy_no, "-", 1, 1)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Regarding content validation
hi,ray.wurlod wrote:...Code: Select all
Field(InLink.policy_no, "-", 1, 1)
could u pls explain how it will work?i mean can u gimme the logic behind it..
Thanks in advance.....
Re: Regarding contant validation
hiveera24 wrote:hi am having policy_no a a column. In this column only am havin hyphens. could u pls explain in detail how to implement it..ray.wurlod wrote:...Code: Select all
Field(InLink.TheString, "-", 1, 1)
Thanks in advance.......
will this logic work if the policy_no not havin hypthen in it. because am having that also.
Thanks...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why did you not mention that fact in your original specification?!!
Would it have been so hard for you to try it, rather than ask?
In this case you are lucky, the function will return the entire input string if it contains no delimiter character.
Would it have been so hard for you to try it, rather than ask?
In this case you are lucky, the function will return the entire input string if it contains no delimiter character.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.