Hi All,
I have a strange behaviour from csplit command on some text files.
I have a comma separated file and data with in double quotes. This file is being generated from Sequential stage of Data stage tool.
This file has 67 fields in each records with some null and blank in the data. When i split the file the new files splitted have only first field in single record. Below is the command i used.
Location: Saint Paul, MN USA / BSD, CentOS, Debian, OS X, Solaris
Posts: 2,288
Thanks Given: 430
Thanked 480 Times in 395 Posts
Hi.
As otheus wrote, there may be a fix, but Solaris 8 is a bit old.
There are people here who would look at this problem, but few, I suspect, are willing to create a dataset that may or may not match what you have.
If you are interested in responses, please post a representative sample of the data, the output, and your desired (or expected) output.
I have access to Solaris 10, so that would be one difference. However, it is often a misunderstanding or misuse of commands that can lead to apparent errors.
Best wishes ... cheers, drl
PS If you post data or code, please learn to use CODE tags around those parts of your post -- it makes the reading easier. -- like this:
Code:
abc 012
To do so, after you paste the code into the editing window, select it with your mouse, then click the # symbol just above the editing window.
Input file:
CLK00027 TESTDATA 0 S 600000 \r
0001RFC 192321 321321 321321 \r
0002 rfd this is testdata1
CLK00027 TESTDATA 0 S 600000 \r
0001RFC 192321 321321 321321 \r
0002 rfd this is testdata2
I Need to split this file into seperate files
file1.txt
CLK00027 ... (1 Reply)
Hi All,
I have recently join the forum and this is my first post....hoping to get a suggestion to a problem that I am facing.
I have a script that works well on ksh unix on AIX server. The below mentioned code checks number of records in an input file starting with 99 and splits it... (1 Reply)
Hello
am trying to split the following top output at the TTY line but having some issues:
System: msisprd Sun Oct 9 09:35:37 2011
Load averages: 0.14, 0.17, 0.16
411 processes: 361 sleeping, 50 running
Cpu states:
CPU LOAD USER NICE SYS ... (3 Replies)
I want to split big files based on a pattern to stdout.
Although csplit works well for me splitting the output into separate files (e.g. xx00, xx01, xx02, ...), the following is not working as expected:
<code>
# assuming pattern occurs less than 100 times
csplit bigfile '%pattern%'... (2 Replies)
I am using GNU csplit to extract chapters from a big file into smaller files.
I want to use the -b option
-b, --suffix-format=FORMAT use sprintf FORMAT instead of %d
but I have failed so far.
1) All the generated files need to have a suffix .txt at the end
2) They have to look like... (1 Reply)
Hello all
The below command works perfeft when executed from the shell prompt.
"csplit -f first Allocation.log.1 "%. Oct 02 .%" {1} "
and generates first00 file.
But it fails if I include the same command in my script.
I am trying to automate some process and this is turning... (1 Reply)
I am trying to use the csplit file on a file that contains records that have more than 2048 characters on a line. The resultant split file seems to ignore the rest of the line and I lose the data.
Is there any way that csplit can handle record lengths greater than 2048?
Thanks (0 Replies)
I have a large file with the first 2 characters of each line determining the type of record. type 03 being a subheader and then it will have multiple 04 records.
eg: 03,xxx,xxxx,xxxx
04,xxxxxxxxxxxxxxxxxxxxxxxxxxxx
04,xxxxxxxxxxxxxxxxxxxxxxxxxxxx
03,xxx,xxx,xxx
... (2 Replies)
Dear Friends,
please help me.
I am using csplit to split the files,
i.e.,
csplit -f filetype_ -n 3 filename '/regexpn/' {5}
which will split file "filename" into 5 subfiles
filetype_000
filetype_001
filetype_002
filetype_003
filetype_004
but if I run the csplit commad again it will... (2 Replies)
