Sponsored Content
Full Discussion: Split records based on '-'
Top Forums UNIX for Advanced & Expert Users Split records based on '-' Post 302519941 by ctsgnb on Thursday 5th of May 2011 12:16:49 PM
Old 05-05-2011
For me it works :

Code:
$ cat tst
ABC|ABC_702148-PARAM
ABC|CDE|BVD|VDGDT|DBDHDYT|DHDHJD|DJDGJGD
123|345|4556|5757|2323|5567786|454353|464645
ABDD|123|SASASA|1224|JJAKSJ|565464|DSDSD|LKLK
A123|123_702148
ABC|CDE|BVD|VDGDT|DBDHDYT|DHDHJD|DJDGJGD
123|345|4556|5757|2323|5567786|454353|464645
ABDD|123|SASASA|1224|JJAKSJ|565464|DSDSD|LKLK
DEF|XYZ_123_1358-PARAM
ABDD|123|SASASA|1224|JJAKSJ|565464|DSDSD|LKLK
ABC|CDE|BVD|VDGDT|DBDHDYT|DHDHJD|DJDGJGD
123|XYZ_123
ABC|CDE|BVD|VDGDT|DBDHDYT|DHDHJD|DJDGJGD
123|345|4556|5757|2323|5567786|454353|464645
ABDD|123|SASASA|1224|JJAKSJ|565464|DSDSD|LKLK
ABDD|123|SASASA|1224|JJAKSJ|565464|DSDSD|LKLK
ABC|ABC_702148-PARAM
ABC|CDE|BVD|VDGDT|DBDHDYT|DHDHJD|DJDGJGD
123|345|4556|5757|2323|5567786|454353|464645
ABDD|123|SASASA|1224|JJAKSJ|565464|DSDSD|LKLK

Code:
$ awk -F\| 'NF<3{x=($2~/-/)?0:1}x' tst
A123|123_702148
ABC|CDE|BVD|VDGDT|DBDHDYT|DHDHJD|DJDGJGD
123|345|4556|5757|2323|5567786|454353|464645
ABDD|123|SASASA|1224|JJAKSJ|565464|DSDSD|LKLK
123|XYZ_123
ABC|CDE|BVD|VDGDT|DBDHDYT|DHDHJD|DJDGJGD
123|345|4556|5757|2323|5567786|454353|464645
ABDD|123|SASASA|1224|JJAKSJ|565464|DSDSD|LKLK
ABDD|123|SASASA|1224|JJAKSJ|565464|DSDSD|LKLK
$

I am not sure to understand what you need, please clarify
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

dynamically split the records

Hi, I was wandering would it be possible to split the record dynamically based on the certain values, for an instance i have a file with record with predefined split value i.e 10 col1 col2 col3 col4 ------------------------ aaaa bbbb 2 44aaaabbbb55cccddd1110 mmn xnmn 3... (6 Replies)
Discussion started by: braindrain
6 Replies

2. Shell Programming and Scripting

Sort & Split records in a file

Hi, I am new to scripting. I need a script to sort and the records in a file and then split them into different files. For example, the file is: H1...................... H2...................... D2.................... D2.................... H1........................... (15 Replies)
Discussion started by: Sunitha_edi82
15 Replies

3. Shell Programming and Scripting

Based on num of records in file1 need to check records in file2 to set some condns

Hi All, I have two files say file1 and file2. I want to check the number of records in file1 and if its atleast 2 (i.e., 2 or greater than 2 ) then I have to check records in file2 .If records in file2 is atleast 1 (i.e. if its not empty ) i have to set some conditions . Could you pls... (3 Replies)
Discussion started by: mavesum
3 Replies

4. Shell Programming and Scripting

split records into different files

Hi All, I want my file to be split based on value of 'N' (passed as argument). If value of 'N' is '2' then 4 new files will be generated from the below source file and the o/p file shoud look like File_$num , where num will be incremental. Source file: 1 2 3 4 5 O/p Files: ... (6 Replies)
Discussion started by: HemaV
6 Replies

5. Shell Programming and Scripting

Split records into multiple records

Hi All, I am trying to split a record into multiple records based on a value. Input.txt "A",1,0,10 "B",2,0,10,15,20 "C",3,11,14,16,19,21,23 "D",1,0,5 My desired output is: "A",1,0,10 "B",2,0,10 "B",2,15,20 "C",3,11,14 "C",3,16,19 "C",3,21,23 (4 Replies)
Discussion started by: kmsekhar
4 Replies

6. Shell Programming and Scripting

Split the Master and Child Records

Hi, I receive a file that has Master record followed by one/more Child Records as shown below & also as attached in the file. Now , The key for the child record is from pos 4 to position 80 in the parent record, now the requirement is to create two files 1. Parent file --> has all the parent... (1 Reply)
Discussion started by: KNaveen
1 Replies

7. Shell Programming and Scripting

Split Records

I have a flat file with 2 columns Id,loc 1,nj:ny:pa 2,pa 3,ca:tx:fl:nj Second colum data is seperated by semi colon and can i have many locations for one id Output i need is 1,nj 1,ny 1,pa 1,pa 3,ca 3,tx 3,fl (1 Reply)
Discussion started by: traininfa
1 Replies

8. Shell Programming and Scripting

Split file based on records

I have to split a file based on number of lines and the below command works fine: split -l 2 Inputfile -d OutputfileMy input file contains header, detail and trailor info as below: H D D D D TMy split files for the above command contains: First File: H DSecond File: ... (11 Replies)
Discussion started by: Ajay Venkatesan
11 Replies

9. Shell Programming and Scripting

Split records

Hi I have a file $cat test a,1;2;3 b,4;5;6;7 c,8;9 I want to split each record to multiple based on semicolon in 2nd field. i.e a,1 a,2 a,3 b,4 b,5 (3 Replies)
Discussion started by: Shivdatta
3 Replies

10. Shell Programming and Scripting

How to split one record to multiple records?

Hi, I have one tab delimited file which is having multiple store_ids in first column seprated by pipe.I want to split the file on the basis of store_id(separating 1st record in to 2 records ). I tried some more options like below with using split,awk etc ,But not able to get proper output. can... (1 Reply)
Discussion started by: jaggy
1 Replies
PX_PUT_DATA_ALPHA(3)					     Library Functions Manual					      PX_PUT_DATA_ALPHA(3)

NAME
PX_put_data_alpha -- Put value into an alpha data field SYNOPSIS
#include <paradox.h> void PX_put_data_alpha(pxdoc_t *pxdoc, char *data, int len, char *value) DESCRIPTION
Converts a string into a value for a data field as it stored in the database file. You must set the target encoding before in order to recode the string. If you do not set the encoding the data will be stored as is. You should use this function instead of accessing the record data directly. data points to the start of the data field in the record. It must be calculated by summing up all field length before the field to operate on and add it to the base pointer of the record. SEE ALSO
PX_put_data_long(3), PX_put_data_double(3), PX_put_data_short(3), PX_put_data_byte(3), PX_put_data_bytes(3) AUTHOR
This manual page was written by Uwe Steinmann uwe@steinmann.cx. PX_PUT_DATA_ALPHA(3)
All times are GMT -4. The time now is 04:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy