Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
senthilt1
Participant
Posts: 134 Joined: Mon Nov 19, 2007 2:17 am
Post
by senthilt1 » Thu Jun 26, 2008 7:55 am
Hi All,
I am having the records with delimiter as ascii value \013.
I wanted to find out the number of delimiter(\013) available in the single record.
I tried it using Count(Inputfield,"\013") but its checking for \013 in the record not for the delimiter.
so if my delimilter is of some special characters, then how to find out the counts in a record?
Could anyone tell me the solution for this?
Thanks,
Senthil P
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Thu Jun 26, 2008 8:05 am
should do the trick for you.
senthilt1
Participant
Posts: 134 Joined: Mon Nov 19, 2007 2:17 am
Post
by senthilt1 » Fri Jun 27, 2008 5:46 am
Hi ArndW,
My Delimiter is Vertical tab. I want to know the count of my Delimiter in a record. i used Count(InputField,CHAR(13)) as you suggested. But its not working.
Please let me know about this.
Thanks,
Senthil P
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Fri Jun 27, 2008 6:15 am
The vertical tab ASCII character is 11, not 13.
senthilt1
Participant
Posts: 134 Joined: Mon Nov 19, 2007 2:17 am
Post
by senthilt1 » Fri Jun 27, 2008 6:34 am
HI ArndW,
You are correct!!!
Now Count(InputField,CHAR(11)) to find out the vertical tab delimiter is working fine.
13 is the octal value for the vertical tab. 11 is the decimal value for the vertical tab
Thanks a lot.
Senthil P
nagarjuna
Premium Member
Posts: 533 Joined: Fri Jun 27, 2008 9:11 pm
Location: Chicago
Post
by nagarjuna » Fri Jun 27, 2008 9:21 pm
Now Its time to mark this topic as resolved :D
Nag