Supressing spaces in pipe-delimited field 1

[rufflocks]

I wish to suppress leading and trailing spaces in a pipe-delimited field so that:
| 123| will become 00123, and
|123 | will become 00123

 

[bigoldbulldog]

use printf or sprintf on it. e.g.

{
printf( "%05d\n", $1)
}

Cheers,
ND

bigoldbulldog@hotmail.com

 

[rufflocks]

Thanks. That works if I want to print the field without leading and trailing spaces.
How about if I want to do some work with the non-space value digit/characters of this field?

 

[dickiebird]

What work d'you wanna do with the digits/characters ?????

Dickie Bird (-)))

 

[rufflocks]

if field is numerics (all 5 digits)
write field to file1
write field to file2.
if field is alpha-numeric (some alpha, some numeric, or all apha, not spaces)
write field to file1
write "1111" to file2.
if field has leading/trailing spaces (remaining vales are numerics)
write with leading zero to file1
write "1111" to file2.

I'm not looking for the code for the above, only how to get the field without the leading/trailing spaces so it can be manipulated.

 

[vgersh99]

nawk -f spaces.awk file.txt

#------------------ spaces.awk

BEGIN {
FS="\\|"
}

{
for( i=1; i <= NF; i++)
if (match($i, &quot;(^[ ][ ]*)|([ ][ ]*$)&quot)
print &quot;spaces [&quot; $i &quot;]&quot;
else
print &quot;no spaces [&quot; $i &quot;]&quot;
}


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

 

[vgersh99]

or better yet:

#----------------- spaces.awk
BEGIN {
FS=&quot;\\|&quot;
}

{
for( i=1; i <= NF; i++)
if (match($i, /(^[ ])|([ ]$)/))
print &quot;spaces [&quot; $i &quot;]&quot;
else
print &quot;no spaces [&quot; $i &quot;]&quot;
}


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