DSXchange

Posted: **Tue Feb 20, 2007 1:27 am**

Hai EXperts,

i have Tab Delimited Record and i Have To Count No.of Delimiters in that record.I am Using DCOUNT() Function.

But, My Problem Is HOW TO SPECIFY TAB SYMBOL IN the DCOUNT FUNCTION.

Posted: **Tue Feb 20, 2007 1:40 am**

Hi,
Welcome Aboard :D !!!
Try with '\t'.

Posted: **Tue Feb 20, 2007 1:48 am**

Also Try with Char(9)

Code: Select all

DCount(Record,Char(9))

Posted: **Tue Feb 20, 2007 3:10 am**

'\t' It's Not Working.

Dcount(Records,Char(9)) Its Working Fine.

Thank U Balaji

Posted: **Tue Feb 20, 2007 3:15 am**

If your aim is to find the no of fields in a record then we can use.....

awk -F'\t' 'END {print NF}' testfile

Not sure about the DCOUNT()

Regards,

Posted: **Tue Feb 20, 2007 3:22 am**

Do you think this topic can be marked as resolved?

DSXchange

Specifying Tab Delimiter Symbol in DCOUNT()

Specifying Tab Delimiter Symbol in DCOUNT()