Issue while splitting a row of record Post: 302355238

Sponsored Content

Top Forums Shell Programming and Scripting Issue while splitting a row of record Post 302355238 by Kattoor on Tuesday 22nd of September 2009 06:27:02 AM

09-22-2009

Registered User

Hi ..
I executed the same script as you given above.but then I am getting the report like,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Code:

Account_Id Date Id Balance
44  9  1000.00n  30
15-10-2173  10  1000.00  42
15-10-2173  10  1200.00  53
01-01-2008  10  1200.00

Then I tried to execute this with one small change in your script,

Code:

sed "s/\.00/.00 \n/" |awk '{ (Just given a single space in between .00 and \n )

Then I am getting the result as follows,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Code:

Account_Id Date Id Balance
44  9  1000.00  n
30  15-10-2173  10  1000.00
42  15-10-2173  10  1200.00
53  01-01-2008  10  1200.00

Last edited by vgersh99; 09-22-2009 at 07:40 AM.. Reason: code tags, PLEASE!

Kattoor

View Public Profile for Kattoor

Find all posts by Kattoor

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Issue with Splitting of file

HI! All Iam running this script ro split the file ,attact a timesatmp to it and then conver it to .tmp extension cd /home/staff/thussain Prefix=Z_PRICE_NEW_`date "+%Y%m%d%H%M%S"` split -3000 -a 5 /home/staff/thussain/Z_PRICE_NEW.txt $Prefix find . -name "$Prefix*" -print | { while read...

2. Shell Programming and Scripting

splitting a record and adding a record to a file

Hi, I am new to UNIX scripting and woiuld appreicate your help... Input file contains only one (but long) record: aaaaabbbbbcccccddddd..... Desired file: NEW RECORD #new record (hardcoded) added as first record - its length is irrelevant# aaaaa bbbbb ccccc ddddd ... ... ...

3. Shell Programming and Scripting

Split a record ( in a row) and make it as new row

Hi All, The following is the scenario id name -------------- 1 William;Johnson 2 Azim;Abdul 3 Grasim . . etc.... I need the following output id name -------------- 1 William 1 Johnson 2 Azim

4. UNIX for Dummies Questions & Answers

Record splitting with AWK

Hi all ! I need your help as quick as possible. My input file like this: bạc t�nh （薄情） 1 . 薄情な．２．夫婦或いは男女の不貞を指す。 b�ch (百，迫)1.100ﾄﾞｿ. tr a m b a c ともいう．２．柏（ｶヽしわ）･　3.圧迫する．４．差し迫った， My propose is take the value in the firt bracket. I used the command like : ...if (index(...

5. Shell Programming and Scripting

Splitting data from one row as multiple columns

Hi I have a file containing some data as follows: 11-17-2010:13:26 64 4 516414 1392258 11-17-2010:13:26 128 4 586868 695603 11-17-2010:13:26 256 4 474937 1642294 11-17-2010:13:32 64 4 378715 1357066 11-17-2010:13:32 128 4 597981 1684006 ...

6. Shell Programming and Scripting

Need help splitting huge single record file

I was given a data file that I need to split into multiple lines/records based on a key word. The problem is that it is 2.5GB or bigger and everything I try in perl or sed causes a Segmentation fault. Can someone give me some other ideas. The data is of the form:...

7. Shell Programming and Scripting

Splitting record into multiple records by appending values from an input field (AWK)

Hello, For the input file, I am trying to split those records which have multiple values seperated by '|' in the last input field, into multiple records and each record corresponds to the common input fields + one of the value from the last field. I was trying with an example on this forum...

8. Shell Programming and Scripting

Exclude the header row while splitting the file

Hi All, i have script like ... "TYPE_ID" "ID" "LIST_ID" "18" "52010" "1059" "18" "52010" "1059" "18" "52010" "1059" "18" "52010" "1059" i am using the below code it's not taking the header row. awk -F"\t" -v file=test1.txt -v file1=test2.txt ' { if(...

9. Shell Programming and Scripting

How to place Record in a row as a column name?

Hi, I want to know how to place a particular field availble in a record as the columnname. Name,Sam,Age,13,School, StJohn Name,Rita,Age,12,School, StMichael, Name,John,Age,14,School, StAnthony I want the output as Name Age School Sam 13 StJohn Rita 12 StMichael John 14...

10. Shell Programming and Scripting

Splitting single row into multiple rows based on for every 10 digits of last field of the row

Hi ALL, We have requirement in a file, i have multiple rows. Example below: Input file rows 01,1,102319,0,0,70,26,U,1,331,000000113200000011920000001212 01,1,102319,0,1,80,20,U,1,241,00000059420000006021 I need my output file should be as mentioned below. Last field should split for...

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Issue with Splitting of file

Discussion started by: mohdtausifsh

2. Shell Programming and Scripting

splitting a record and adding a record to a file

Discussion started by: rsolap

3. Shell Programming and Scripting

Split a record ( in a row) and make it as new row

Discussion started by: kottursamy

4. UNIX for Dummies Questions & Answers

Record splitting with AWK

Discussion started by: maixu134

5. Shell Programming and Scripting

Splitting data from one row as multiple columns

Discussion started by: annazpereira

6. Shell Programming and Scripting

Need help splitting huge single record file

Discussion started by: leolson

7. Shell Programming and Scripting

Splitting record into multiple records by appending values from an input field (AWK)

Discussion started by: imtiaz99

8. Shell Programming and Scripting

Exclude the header row while splitting the file

Discussion started by: bmk

9. Shell Programming and Scripting

How to place Record in a row as a column name?

Discussion started by: sidnow

10. Shell Programming and Scripting

Splitting single row into multiple rows based on for every 10 digits of last field of the row

Discussion started by: kotra