12-29-2009
comma delimited file
How would you know the difference in comma's when there are comma's as delimiers between fields and comma's inside the fields?
Sometimes fields are inside quotes " characters.
Can you show a sample?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
--------------------------------------------------------------------------------
Hi All,
I am reading some logfiles and parsing data and printing to some textfile.
Here is my code
OLDIFS=$IFS
IFS='
' # just a newline, in single quotes
while read data
do
if
then
#Parsing the... (4 Replies)
Discussion started by: subin_bala
4 Replies
2. Shell Programming and Scripting
Attached is a streamed EDI ANSI X12 output where the segment terminator/delimiter is a tilde ~ character.
Is it possible to do the following pseudo-code in a unix script (using either sed, awk and/or grep)?
Open file StreamedOutput.txt
Search for ISA and delete the data up to the tilde ~ char... (7 Replies)
Discussion started by: sapedi
7 Replies
3. Shell Programming and Scripting
Hey guys,
I have this file generated by me... i want to create some HTML output from it.
The problem is that i am really confused about how do I go about reading the file.
The file is in the following format:
TID1 Name1 ATime=xx AResult=yyy AExpected=yyy BTime=xx BResult=yyy... (8 Replies)
Discussion started by: umar.shaikh
8 Replies
4. Shell Programming and Scripting
Hi,
I wanted to compare EDI files present in Two different Directories which can be related by the file names. While comparing the EDI files i have to skip selected segments such as "ISA" "IEA" and "GS" "GE" since this may have datetime stamp and different "Sender" "Receiver" Qual.
and... (3 Replies)
Discussion started by: Sivas
3 Replies
5. UNIX for Dummies Questions & Answers
I am using MKS tool kit on windows server. One config variable is defined in windows environment and I am trying to use that variable.
# Below RootDir is defined in windows
RootDir="\\f01\var"
# in unix script
details="$RootDir/src|$RootDir/tgt"
src=`echo $details|awk -F '|' '{print... (1 Reply)
Discussion started by: madhukalyan
1 Replies
6. Shell Programming and Scripting
Scripting geeks please advice how this script should parse the input parameter to File Name convention to search the strings. Enclosed is the basic view of the search architecture.
##*******************************************************************************************************
## ... (2 Replies)
Discussion started by: raghunsi
2 Replies
7. Shell Programming and Scripting
Hello All,
I am trying to parse a log file and i got this code from one of the good forum colleagues, However i realised later there is a problem with this awk script, being naive to awk world wanted to see if you guys can help me out.
AWK script:
awk '$1 ~ "^WRITER_" {p=1;next}... (18 Replies)
Discussion started by: Ariean
18 Replies
8. Shell Programming and Scripting
I've one EDI file which is to be parsed into 7 different file.
I managed to extract required segments for a file(HEADER) to a separate file(sample3.dat) and is given below.
$ cat sample3.dat
REF*EI*273543997~
REF*2U*HELLO~
REF*G2*77685|132~
CLM*1000*0.00***12>B>1*N*A*Y*I~
CN1*05~... (5 Replies)
Discussion started by: ashokv3
5 Replies
9. Shell Programming and Scripting
Hi
I am trying to parse a grep output using awk. It works fine individually and not working under the loop with variable name assigned.
cat > file.txt
dict=/dictr/abcd/d1/wq:/dictr/abcd/d2/wq:/dictr/abcd/d3/wq:
sample tried code
Nos=`grep -w "dict" file.txt | awk -F"=" '{print... (10 Replies)
Discussion started by: ananan
10 Replies
10. Shell Programming and Scripting
sorry I messed up the last post with too many mistakes and corrections so I closed it and opening a new one which should be clear to everyone .my apologies to the admins.
I am using sun solaris and Linux , what I want is SED to print any string (or output it to a file preferably) that does... (2 Replies)
Discussion started by: boncuk
2 Replies
LEARN ABOUT SUNOS
bufsplit
bufsplit(3GEN) String Pattern-Matching Library Functions bufsplit(3GEN)
NAME
bufsplit - split buffer into fields
SYNOPSIS
cc [ flag ... ] file ... -lgen [ library ... ]
#include <libgen.h>
size_t bufsplit(char *buf, size_t n, char **a);
DESCRIPTION
bufsplit() examines the buffer, buf, and assigns values to the pointer array, a, so that the pointers point to the first n fields in buf
that are delimited by TABs or NEWLINEs.
To change the characters used to separate fields, call bufsplit() with buf pointing to the string of characters, and n and a set to zero.
For example, to use colon (:), period (.), and comma (,), as separators along with TAB and
NEWLINE:
bufsplit (":.,
", 0, (char**)0 );
RETURN VALUES
The number of fields assigned in the array a. If buf is zero, the return value is zero and the array is unchanged. Otherwise the value is
at least one. The remainder of the elements in the array are assigned the address of the null byte at the end of the buffer.
EXAMPLES
Example 1: Example of bufsplit() function.
/*
* set a[0] = "This", a[1] = "is", a[2] = "a",
* a[3] = "test"
*/
bufsplit("This is a test
", 4, a);
NOTES
bufsplit() changes the delimiters to null bytes in buf.
When compiling multithreaded applications, the _REENTRANT flag must be defined on the compile line. This flag should only be used in mul-
tithreaded applications.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|MT-Level |MT-Safe |
+-----------------------------+-----------------------------+
SEE ALSO
attributes(5)
SunOS 5.10 29 Dec 1996 bufsplit(3GEN)