Sponsored Content
Full Discussion: Split values using awk
Top Forums UNIX for Beginners Questions & Answers Split values using awk Post 303046308 by nezabudka on Thursday 30th of April 2020 11:57:04 AM
Old 04-30-2020
Hi
How about sed?
Code:
sed -r ':1;s/^([^,]+)\s*,\s*([^;]+);/\1, \2\n\1, /;t1' file
Name , Company_Worked (Header)
Asley, IBM
Asley, Amazon
Asley, BOA
Asley, Google
King.Jr, Wipro
King.Jr, Microsoft
King.Jr, AMZ

--- Post updated at 19:57 ---

If it turns out that a person works in only one company, then there will be no space after the decimal point.
Fix it
Code:
sed -r '1b;:1;s/^([^,]+,)([^;]*);/\1\2\n\1/;t1;s/,/& /g' file
Name , Company_Worked (Header)
Olesya, Housewife
Asley, IBM
Asley, Amazon
Asley, BOA
Asley, Google
King.Jr, Wipro
King.Jr, Microsoft
King.Jr, AMZ

This User Gave Thanks to nezabudka For This Post:
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Split a file with no pattern -- Split, Csplit, Awk

I have gone through all the threads in the forum and tested out different things. I am trying to split a 3GB file into multiple files. Some files are even larger than this. For example: split -l 3000000 filename.txt This is very slow and it splits the file with 3 million records in each... (10 Replies)
Discussion started by: madhunk
10 Replies

2. Shell Programming and Scripting

split variable values into array

i have these values inside variable $blah BUNGA TERATAI 3 5055 ITH 1 0 0 0 1 1 JADE TRADER 143W ITH 4 0 0 0 4 4 MOL SPLENDOR 0307A ITH 3 0 0 0 3 3 so how do I split them into array with the... (4 Replies)
Discussion started by: finalight
4 Replies

3. Shell Programming and Scripting

How to pick values from column based on key values by usin AWK

Dear Guyz:) I have 2 different input files like this. I would like to pick the values or letters from the inputfile2 based on inputfile1 keys (A,F,N,X,Z). I have done similar task by using awk but in that case the inputfiles are similar like in inputfile2 (all keys in 1st column and values in... (16 Replies)
Discussion started by: repinementer
16 Replies

4. Shell Programming and Scripting

AWK: read values from file1; search for values in file2

I have read another post about this issue and am wondering how to adapt it to my own, much simpler, issue. I have a file of user IDs like so: 333333 321321 546465 ...etc I need to take each number and use it to print records wherein the 5th field matches the user ID pulled from the... (2 Replies)
Discussion started by: Bubnoff
2 Replies

5. Shell Programming and Scripting

Split the values

ABC|DFE HYK|YUI is the contents in file. I am using the for loop for for value_list in `cat ./file` ; do echo $value_list cat use_firstvalue > second_value done I have to split the based on '|' and it should be used as a varaible in the cat command. How to do that. Please help me... (3 Replies)
Discussion started by: sandy1028
3 Replies

6. Shell Programming and Scripting

awk to split one field and print the last two fields within the split part.

Hello; I have a file consists of 4 columns separated by tab. The problem is the third fields. Some of the them are very long but can be split by the vertical bar "|". Also some of them do not contain the string "UniProt", but I could ignore it at this moment, and sort the file afterwards. Here is... (5 Replies)
Discussion started by: yifangt
5 Replies

7. Shell Programming and Scripting

Shell Script:split the values

Hi, I have file like below as file.txt Linux sptpp1a 2.6.18 348.1.1.el5 xxxxx 05/02/2013 %usr %sys %wio %idle 14:18:30 0 1 0 99 14:18:40 1 1 0 98 14:18:50 1 1 0 98 14:19:00 ... (5 Replies)
Discussion started by: Mani_apr08
5 Replies

8. Shell Programming and Scripting

Split file according to column values

Hi all, I am trying to split a file by the values of the FIRST column. The following awk works to split the file by the value of the LAST column -- How can I alter this to divide the column by the FIRST column?? awk -F"\t" '{ print > $NF ; close($NF)}' filename1Thanks! (5 Replies)
Discussion started by: owwow14
5 Replies

9. Shell Programming and Scripting

awk file to read values from Db2 table replacing hard coded values

Hi, I want to replace a chain of if-else statement in an old AWK file with values from Db2 table or CSV file. The part of code is below... if (start_new_rec=="true"){ exclude_user="false"; user=toupper($6); match(user, "XXXXX."); if (RSTART ==2 ) { ... (9 Replies)
Discussion started by: asandy1234
9 Replies

10. Shell Programming and Scripting

Split a content in a file with specific interval base on the delimited values using UNIX command

Hi All, we have a requirement to split a content in a text file every 5 rows and write in a new file . conditions: if 5th line falls between center of the statement . it should look upto after ";" files are below format: 1 UPDATE TABLE TEST1 SET VALUE ='AFDASDFAS' 2 WHERE... (3 Replies)
Discussion started by: KK230689
3 Replies
clamz(1)						      General Commands Manual							  clamz(1)

NAME
clamz - download MP3 music files from Amazon.com SYNOPSIS
clamz [ options ] amz-file ... DESCRIPTION
clamz is a little command-line program to download MP3 files from Amazon.com's music store. It is intended to serve as a substitute for Amazon's official MP3 Downloader, which is not free software (and therefore is only available in binary form for a limited set of plat- forms.) clamz can be used to download either individual songs or complete albums that you have purchased from Amazon. In order to use clamz, you must first enable the ``MP3 dowloader mode'' by visiting the following URL: http://www.amazon.com/gp/dmusic/after_download_manager_install.html?AMDVersion=1.0.9 If you are outside the US, replace `amazon.com' with the corresponding domain for your country (e.g., amazon.co.uk for the UK, or amazon.fr for France.) Amazon does not allow anyone to purchase MP3 files from outside their country of residence. To download the contents of an AMZ file into the current directory, just run clamz some-file-name.amz More advanced options are listed below. OPTIONS -o name-format, --output=name-format Set the name of the downloaded file(s). This may contain any of several variables which are derived from the input AMZ file; see FORMAT VARIABLES below. Note that the format string should be enclosed in single quotes, to stop the shell from expanding variables itself. -d directory-format, --output-dir=directory-format Set the directory where the downloaded files should be placed. (If this directory does not exist, it will be created.) This may also contain format variables. -r, --resume Resume downloading a partially-downloaded album. (By default, if you are downloading a file named foo.mp3, and the file foo.mp3 already exists in the destination directory, clamz will rename the new file to foo.mp3.1 to avoid overwriting the old file. If the -r option is used, clamz will instead assume that the first part of the file has already been downloaded, and will resume download- ing from where it left off.) -i, --info Rather than downloading anything, just display detailed information about the given AMZ file(s) to standard output. -x, --xml Rather than downloading anything, print the raw, decrypted XML data from the AMZ file to standard output. -v, --verbose Display detailed information while downloading. -q, --quiet Turn off the normal progress display; display only error messages. --forbid-chars=characters Do not allow the given characters to be used in output filenames. Note that control characters and slashes may never be used in filenames. --allow-chars=characters Opposite of the above; remove the given characters from the set of disallowed characters. --allow-uppercase Allow uppercase letters in filenames. --forbid-uppercase Do not allow uppercase letters in filenames. --utf8-filenames Use UTF-8 when writing filenames (the default behavior is to use UTF-8 if the system locale says so, otherwise ASCII.) --ascii-filenames Use only ASCII characters in filenames. --help Print out a summary of options. --version Print out version information. FORMAT VARIABLES As part of a name-format or directory-format option, you may include references to environment variables (e.g., $HOME) or to the `xdg-user- dirs' configuration variables (e.g., $XDG_MUSIC_DIR or $XDG_DESKTOP_DIR.) In addition, the following special variables are defined for each track, based on the information provided in the AMZ file, and subject to the above configuration options (--forbid-chars, --forbid-uppercase, etc.) ${title}, ${creator}, ${tracknum}, ${discnum}, ${genre}, ${asin} Title, creator, track number, disc number, genre, and ASIN (Amazon Standard Identification Number) of each individual track. ${album}, ${album_artist}, ${album_asin} Title, primary artist, and ASIN of the album the track comes from. (This information is available both for single-track and full- album downloads.) ${suffix} Suffix of the output file (currently only `mp3'.) ${amz_title}, ${amz_creator}, ${amz_genre}, ${amz_asin} These variables formerly contained metadata for the AMZ file as a whole; current AMZ files do not contain this information. Using these variables is not recommended. Similar to shell variable expansion, you can also use the following conditional expressions: ${var:-string} Expands to the value of variable var if it is defined and non-empty; otherwise, expands to string (which may itself contain variable references.) ${var:+string} Expands to string if the variable var is defined and non-empty; otherwise, expands to an empty string. Note that when you include format variables in a command-line argument, you will usually need to enclose the argument in single quotes ('...'), or insert a backslash before the `$', to prevent the shell from trying to expand the variables itself. FILES
$HOME/.clamz/config General configuration file, providing default settings for the --output, --forbid-chars, --allow-uppercase and --utf8-filenames options. $HOME/.clamz/amzfiles/ Directory containing backup copies of AMZ files. $HOME/.clamz/logs/ Directory containing log files. ENVIRONMENT
http_proxy HTTP proxy to use for downloading files; use `server:port' to specify a port number. AUTHOR
Benjamin Moody <floppusmaximus@users.sf.net> Clamz 0.5 October 2011 clamz(1)
All times are GMT -4. The time now is 11:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy