DSXchange

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.

ray.wurlod wrote:

Code: Select all

Field(InLink.TheString, "-", 1, 1)

...

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..

Thanks in advance.......

ray.wurlod wrote:

Code: Select all

Field(InLink.policy_no, "-", 1, 1)

...

hi,
could u pls explain how it will work?i mean can u gimme the logic behind it..

Thanks in advance.....

veera24 wrote:

ray.wurlod wrote:

Code: Select all

Field(InLink.TheString, "-", 1, 1)

...

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..

Thanks in advance.......

hi
will this logic work if the policy_no not havin hypthen in it. because am having that also.

Thanks...

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.