Convert to digit

[nguyenb9]

I have a file look like:

HOD2|741|301||Y|
HOD2|751|30144||Y|
HOD2|761|3012||Y|

I want the third field to be coverted into how many digits in that field.

Result:
HOD2|741|3||Y|
HOD2|751|5||Y|
HOD2|761|4||Y|

Thank you for you help.

 

[CaKiwi]

Try

BEGIN {OFS=FS="|"}
{
$3=length($3)
print
}

CaKiwi

"I love mankind, it's people I can't stand" - Linus Van Pelt

 

[nguyenb9]

You are the man

Thank you

 

[vgersh99]

Are you sure?
[pun intended]

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+