Cut command issue with shell script

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Cut command issue with shell script
# 8  
Old 11-05-2013
Yes Akshay I tried the ones you posted on post #5, but they didn't work as expected

492|3076394|SP40|1030028694570|20120125|20120207|13530392|||31||CHAPMAN PLACE|||COLCHESTER|ESSEX|CO4 5ZJ|ADI_001|7|_A|E|A|811|2|0151|EMEB|N|EMEB|N|EMEB|N|1|2|3|4|5|6|7|

Expected output
492|3076394|SP40|1030028694570|20120125|20120207|13530392|||31||CHAPMAN PLACE|||COLCHESTER|ESSEX|CO4 5ZJ|7|_A|E|A|811|2|0151|EMEB|N|EMEB|N|EMEB|N|
That is it should remove 18th feild and all the feilds from after 31th feild

# 9  
Old 11-05-2013
awk 'NF>17{for (i=17; i<=30; i++) $i=$(i+1); NF=31; $NF=""}1' FS=\| OFS=\| file
492|3076394|SP40|1030028694570|20120125|20120207|13530392|||31||CHAPMAN PLACE|||COLCHESTER|ESSEX|ADI_001|7|_A|E|A|811|2|0151|EMEB|N|EMEB|N|EMEB|N|

# 10  
Old 11-06-2013
I tried the above command but its not working, request you to have a look at the below example,

$ [XXXX] $ awk 'NF>17{for (i=17; i<=30; i++) $i=$(i+1); NF=31; $NF=""}1' FS=\| OFS=\| sample_test_file

492|3076394|SP40|1030028694570|20120125|20120207|13530392|||31||CHAPMAN PLACE|||COLCHESTER|ESSEX|ADI_001|7|_A|E|A|811|2|0151|EMEB|N|EMEB|N|EMEB|N||1|2|3|4|5|6|7|

$ [XXX]

# 11  
Old 11-06-2013
which is your default awk mawk or gawk ?
# 12  
Old 11-06-2013
What happens if you set NF=20 in your awk?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Issue with CUT command

Hi All, I am facing an issue while cutting fields with comma delimiter. There are many records with Double quotes in between. My data: aaa,bbb,"ccc, ddd",eee,fff,"ggg ,hhh",iii When i use cut command with comma delimiter, i am getting wrong data like field1=aaa field2=bbb field3="ccc... (3 Replies)
Discussion started by: krishna_gnv
3 Replies

2. Shell Programming and Scripting

Cut command issue

Need help to append a pipe at end of the line immediately after the cut command, I have an Input flat file with 16 feilds and I am removing the 16th feild by using the cut command as shown, Input: 354|||||CORPORTATION||||NENE PARADE|||WISBECH|CAMBRIDGESHIRE|PE13 3BY|100001| I... (5 Replies)
Discussion started by: Aditya_001
5 Replies

3. Shell Programming and Scripting

FTP command issue in shell script

Hi All I am using following code in my shell script to send the file to a mainframe server. ftp -in $FTP_IP_SEND <<END_OF_FTP >$LOG_DIR/ProviderExportFTP.log quote user $FTP_USER_SEND quote pass $FTP_PASS_SEND ascii send ./ProviderExport.txt 'PROJ.PDRCACTS.FD87050.EXPORT' (REPLACE... (3 Replies)
Discussion started by: Renjith180282
3 Replies

4. Shell Programming and Scripting

CUT Command and grep issue

I am trying to grep the oracle erros evry day from the logs file. My problem is : -rw-r----- 1 tibcolm tibco 17438361 Apr 5 11:59 RetryService-RetryService.log -rw-r----- 1 tibcolm tibco 245303 Apr 5 12:00 ResponseService-ResponseService.log -rw-r----- 1 tibcolm tibco 2122654 Apr 5 12:00... (4 Replies)
Discussion started by: neeraj617
4 Replies

5. Shell Programming and Scripting

korn shell to cut command output

hello, i use following command: md5sum TEST.xml the output looks like: 900hjidur84hjr938ikv TEST.xml as you can see, the first part is the md5 code, the second part is the file name, but i only want the first part(md5 code), and save it to a file, how to do that? thanks. (2 Replies)
Discussion started by: zbc
2 Replies

6. Shell Programming and Scripting

Cut in shell script

Hi All, Am a Beginner to shell scripting, so please pardon my question. Below is the file format of file a.txt a.txt F=3 a|b|c|d 1|2|3|4 as|as|asd|asd Aas|as|asd|ada In the above file format, i have record count of total no of records excluding the header file here 3 , this varies... (2 Replies)
Discussion started by: sp999
2 Replies

7. Shell Programming and Scripting

cut command issue from a line of text

Hi, I got a line of text which has spaces in between and it is a long stream of characters. I want to extract the text from certain position. Below is the line and I want to take out 3 characters from 86 to 88 character position. In this line space is also a character. However when using cut... (5 Replies)
Discussion started by: asutoshch
5 Replies

8. Shell Programming and Scripting

Problem using cut command in shell script

I'm new to shell programming, and am having a problem in a (Korn) shell program, which boils down to this: The program reads a record from an input file and then uses a series of "cut" commands to break the record into parts and assign the parts to variables. There are no delimiters in the... (2 Replies)
Discussion started by: joroca
2 Replies

9. Shell Programming and Scripting

How to cut, concatenate data in Shell Script

Hello All,, I'm very new to Unix and I'm more in SAP ABAP. I have a requirement for a shell script which will accept one parameter as Input file name(with directory) e.g : /sapdata/deubank/dbdirect/out/deu01deupe/in/deu01deupe20051207111320.pmt In the shell script I have to make two more... (2 Replies)
Discussion started by: vasan_srini
2 Replies

10. UNIX for Dummies Questions & Answers

Shell script: Cut / (slash) character in string

I have a string "\/scratch\/databases\". I want to have a new string "\/scratch\/databases" by cutting last '\' character using shell script. I can't do this Please help me. Thanks in advance ThuongTranVN (4 Replies)
Discussion started by: ThuongTranVN
4 Replies
Login or Register to Ask a Question