TRIM5

!/bin/bash

export_zmemo.sh

DELIMITER=”¬”
isql -S SERVER -U user -P pass -s”$DELIMITER” -b -w7500 <<EOF
SET NOCOUNT ON
GO
SELECT * FROM ZMemo
GO
EOF | \
awk -F”$DELIMITER” ‘{
for(i=1; i<=NF; i++) {
gsub(/^[ \t]…


This content originally appeared on DEV Community and was authored by Query Filter

!/bin/bash

export_zmemo.sh

DELIMITER="¬"
isql -S SERVER -U user -P pass -s"$DELIMITER" -b -w7500 <<EOF
SET NOCOUNT ON
GO
SELECT * FROM ZMemo
GO
EOF | \
awk -F"$DELIMITER" '{
for(i=1; i<=NF; i++) {
gsub(/^[ \t]+|[ \t]+$/, "", $i)
printf "%s%s", $i, (i<NF ? "'"$DELIMITER"'" : "\n")
}
}' | \
grep -v "^$DELIMITER*$"


This content originally appeared on DEV Community and was authored by Query Filter


Print Share Comment Cite Upload Translate Updates
APA

Query Filter | Sciencx (2025-10-31T23:43:44+00:00) TRIM5. Retrieved from https://www.scien.cx/2025/10/31/trim5/

MLA
" » TRIM5." Query Filter | Sciencx - Friday October 31, 2025, https://www.scien.cx/2025/10/31/trim5/
HARVARD
Query Filter | Sciencx Friday October 31, 2025 » TRIM5., viewed ,<https://www.scien.cx/2025/10/31/trim5/>
VANCOUVER
Query Filter | Sciencx - » TRIM5. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2025/10/31/trim5/
CHICAGO
" » TRIM5." Query Filter | Sciencx - Accessed . https://www.scien.cx/2025/10/31/trim5/
IEEE
" » TRIM5." Query Filter | Sciencx [Online]. Available: https://www.scien.cx/2025/10/31/trim5/. [Accessed: ]
rf:citation
» TRIM5 | Query Filter | Sciencx | https://www.scien.cx/2025/10/31/trim5/ |

Please log in to upload a file.



There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.

Related Posts