Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Reshaping file via awk

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Reshaping file via awk
# 1  
Old 08-02-2017
Reshaping file via awk
I have a huge csv file which need to modify columns, im sharing one line of the file can anybody help to convert with awk.

csv :
Code:
MBP1R13;ISTC211;61234;5130;48441;430;10612;9662;3827687;1342995;1513;ISTC2;64750;AVRUPA_MME_POOL;UNLOCKED;ENABLED;F1

final:
Code:
ISTC2   2       MBP1R13 ISTC211 61234   5130    48441   430     10612   9662    3827687 1342995 1513    ISTC2   64750

thanks in advance.
Last edited by Scrutinizer; 08-02-2017 at 04:40 AM.. Reason: code tags
# 2  
Old 08-02-2017
Hi,

If you issue the command:
Code:
awk -F\; '{print $12, 2, $1, $2}' OFS='\t' file

This will produce
Code:
ISTC2	2	MBP1R13	ISTC211

I think you can figure out the rest yourself, no?

--
Note: I could not find the second output field ("2") in your input file, so I just printed a "2"
# 3  
Old 08-02-2017
Welcome to the forum.

Any attempts / ideas / thoughts from your side?

Mainly the task seems to be rearranging / suppressing the line's fields; but, where does the "2" in field 2 come / is derived from?
# 4  
Old 08-03-2017
Thanks Scrutinizer problem solved, i got another table which includes 2. column,


now i have another one :

Code:
MBP1B16;ATCAD2;286-01-xxx-yyy;42;55

i need to seperate the red marked two digit as shown below

Code:
ATCAD   MBP1B16 ATCAD2  286     1       xxx  yyy    4       2      55


this is where i stuck:
Code:
awk -F '[;-]' '{print $12= substr($2, 1, 5), $1, $2, $3, $4= substr($4, 2), $5, $6, $7= substr($7, 1, 1), $7= substr($7, 2, 1)}' OFS='\t' file

thanks in advance.
Last edited by Don Cragun; 08-03-2017 at 06:39 PM.. Reason: Add CODE for sample input and output tags again.
# 5  
Old 08-03-2017
In the future, please start a new thread to discuss a new problem. For the new problem you posted in post #4, you problems are that:
  1. your 1st assignment to field 7 overwrote the data you are trying to extract in the 2nd call to substr() on that field, (and there is no reason to make any of those assignments), and
  2. you didn't make any attempt to print field 8.
Try this instead:
Code:
awk -F '[;-]' '{print substr($2, 1, 5), $1, $2, $3, substr($4, 2), $5, $6, substr($7, 1, 1), substr($7, 2, 1), $8}' OFS='\t' file

# 6  
Old 08-03-2017
Thanks a lot Don Cragun
I will pay attention forum rules.
br.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Use while loop to read file and use ${file} for both filename input into awk and as string to print

I have files named with different prefixes. From each I want to extract the first line containing a specific string, and then print that line along with the prefix. I've tried to do this with a while loop, but instead of printing the prefix I print the first line of the file twice. Files:... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

2. Shell Programming and Scripting

Awk: Print count for column in a file using awk

Hi, I have the following input in a file & need output as mentioned below(need counter of every occurance of field which is to be increased by 1). Input: 919143110065 919143110065 919143110052 918648846132 919143110012 918648873782 919143110152 919143110152 919143110152... (2 Replies)
Discussion started by: siramitsharma
2 Replies

3. Shell Programming and Scripting

awk command to compare a file with set of files in a directory using 'awk'

Hi, I have a situation to compare one file, say file1.txt with a set of files in directory.The directory contains more than 100 files. To be more precise, the requirement is to compare the first field of file1.txt with the first field in all the files in the directory.The files in the... (10 Replies)
Discussion started by: anandek
10 Replies

4. Shell Programming and Scripting

Split File by Pattern with File Names in Source File... Awk?

Hi all, I'm pretty new to Shell scripting and I need some help to split a source text file into multiple files. The source has a row with pattern where the file needs to be split, and the pattern row also contains the file name of the destination for that specific piece. Here is an example: ... (2 Replies)
Discussion started by: cul8er
2 Replies

5. Shell Programming and Scripting

Converting an scim .bin.user file to a stardict tab file possible with awk?

Hi all, Here is a scim sample.bin.user file a string1 0 a string2 0 a string3 63 b string4 126 c string5 315 d string6 0 e string7 63 e string8 126 f string9 0 I like to convert this into a dict.tab file to be compiled by the ... (4 Replies)
Discussion started by: hk008
4 Replies

6. Shell Programming and Scripting

write awk command into file using awk

hi, i want to write my nawk command into a file. i want to write: awk 'NR==14 && $NF!="Set."{print "l ./gcsw "r" '"'"'lt all;"p"'"'"'"} NR==5{r=$2} NR==3{p=$2 FS $3 FS $4 FS $5}' $logfile > /home/gc_sw/again.mos'"'"' into gc.mos file. this is my code: awk '{print "awk 'NR==14 &&... (6 Replies)
Discussion started by: gc_sw
6 Replies

7. Shell Programming and Scripting

Parse file using awk and work in awk output

hi guys, i want to parse a file using public function, the file contain raw data in the below format i want to get the output like this to load it to Oracle DB MARWA1,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00 MARWA2,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00 this the file raw format: Number of... (6 Replies)
Discussion started by: dagigg
6 Replies

8. Shell Programming and Scripting

Read a file and search a value in another file create third file using AWK

Hi, I have two files with the format shown below. I need to read first field(value before comma) from file 1 and search for a record in file 2 that has the same value in the field "KEY=" and write the complete record of file 2 with corresponding field 2 of the first file in to result file. ... (11 Replies)
Discussion started by: King Kalyan
11 Replies

9. Shell Programming and Scripting

Need help with awk - how to read a content of a file from every file from file list

Hi Experts. I need to list the file and the filename comes from the file ListOfFile.txt. Basicly I have a filename "ListOfFile.txt" and it contain Example of ListOfFile.txt /home/Dave/Program/Tran1.P /home/Dave/Program/Tran2.P /home/Dave/Program/Tran3.P /home/Dave/Program/Tran4.P... (7 Replies)
Discussion started by: tanit
7 Replies
Login or Register to Ask a Question