DSXchange

Posted: **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

Posted: **Thu Jun 26, 2008 8:05 am**

Code: Select all

Count(InputField,CHAR(13))

should do the trick for you.

Posted: **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

Posted: **Fri Jun 27, 2008 6:15 am**

The vertical tab ASCII character is 11, not 13.

Posted: **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

Posted: **Fri Jun 27, 2008 9:21 pm**

Now Its time to mark this topic as resolved :D

DSXchange

Count of Delimiter(special character) in a Record

Count of Delimiter(special character) in a Record