10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
Below are the sample files. x.txt is from an Excel file that is a list of users from Windows and y.txt is a list of database account.
$ head -500 x.txt y.txt
==> x.txt <==
USER01 ... (3 Replies)
Discussion started by: newbie_01
2. Shell Programming and Scripting
I've obviously had a senior moment here, what I'm trying to do is set the number of fields to 35 in a csv these should be appended to the end of the line. But what I'm getting is:-
$ head out_file_01.txt
N1000,024,2809003,,,3,DYNAMIC AVLEASE INC,PO BOX... (10 Replies)
Discussion started by: gull04
3. Shell Programming and Scripting
If a file has following kind of data, comma delimited
My required output must have only 4 columns with comma delimited
I have tried many awk command using ORS="" but couldnt progress (10 Replies)
Discussion started by: mdkm
4. UNIX for Dummies Questions & Answers
what I am trying to get:
I tried to create first an UDF for printing repeats, but I think I have an issue with my END section or my array:
function repeat(str, n, rep, i)
... (6 Replies)
Discussion started by: beca123456
5. Shell Programming and Scripting
I need to post-process some data files which have variable (and periodic) number of fields. For example, I need to square (data -> data*data) the folowing data file: -5.34281E-28 -3.69822E-29 8.19128E-29 9.55444E-29 8.16494E-29 6.23125E-29
4.42106E-29 2.94592E-29 1.84841E-29 ... (5 Replies)
Discussion started by: radudownload
6. Shell Programming and Scripting
I want to use awk to split fields and put them into a file
but I don't know the number of fields
for example, in the following line
Ports: 22/filtered/tcp//ssh///, 53/open/tcp//tcpwrapped///, 111/filtered/tcp//rpcbind///, 543/filtered/tcp//klogin///, 544/filtered/tcp//kshell///,... (3 Replies)
Discussion started by: esolvepolito
7. Shell Programming and Scripting
I have a CSV file with a variable number of fields per record. How do I print lines of a certain number of fields only? Several permutations of the following (including the use of escape characters) have failed to retrieve the line I'm after (1,2,3,4)...
$ cat myfile
$ # Print... (1 Reply)
Discussion started by: cs03dmj
8. Shell Programming and Scripting
Have a file seperated by "~" and no of fields is 104. When i try to run awk, it erros out.
awk: record `B~A31~T24_STF~~~2009...' has too many fields
Any idea how can i extract a specific filed with this many fields in a row.
Kindly help (3 Replies)
Discussion started by: srivat79
9. UNIX for Dummies Questions & Answers
i need help with a little problem i am having.
i need to count the number of fields that are in a saved variable so i can use that number to make a different function work properly.
is there a way of doing this without using SED/AWK?
anything would be greatly appreciated (4 Replies)
Discussion started by: strasner
10. Shell Programming and Scripting
I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want.
The vendor wants me to submit three fields to them. Field 1 is the studentid field,... (4 Replies)
Discussion started by: axo959