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
Date::Manip::ConfigFile(3)				User Contributed Perl Documentation				Date::Manip::ConfigFile(3)

NAME
Date::Manip::ConfigFile - sample config file DESCRIPTION
Date::Manip is a highly configurable module. Many of the options can be set in a config file. This document includes a sample config file. The config file consists of three sections. The first section is config variables. This is described more fully in the Date::Manip::Config document. The second section is the holiday definition section. The third section is the event definition section. These are both described more fully in the Date::Manip::Holidays document. SAMPLE CONFIG FILE
The sample config file below works for newer versions of Date::Manip. Some of the config variables may change, or be deprecated, and some may not work with earlier versions of Date::Manip, so it is strongly suggested that you check out the documentation for the version of Date::Manip you are using to confirm any of the config variables you want to include. ################################ # CONFIG VARIABLES ################################ # See Date::Manip::Config man page for a description of all # config variables. # To include configuration information from additional # config files: ConfigFile = /path/to/another/config/file ConfigFile = /path/to/another/config/file2 # For handling other languages Language = English DateFormat = US Encoding = # Set the current timezone: SetDate = now,America/New_York # Set the work work WorkWeekBeg = 1 WorkWeekEnd = 5 WorkDay24Hr = 0 WorkDayBeg = 08:00 WorkDayEnd = 17:00 TomorrowFirst = 1 # Misc. variables YYtoYYYY = 89 FirstDay = 1 Jan1Week1 = 0 Printable = 0 DefaultTime = midnight RecurRange = none ################################ # HOLIDAYS ################################ # See the Date::Manip::Holidays man page for a description of # this section. *HOLIDAYS # FEDERAL HOLIDAYS ################## # You can express New Year's Day as the actual day (Jan 1) # or the observed day (Jan 1 or the nearest week day). # You can't include BOTH because once a day is marked as # a holiday, a second definition will treat it the same # as a weekend and choose another day to assign the holiday # to (so there would be two days designated as New Years). # Jan 1 = New Year's Day 1*1:0:1:0:0:0*DWD = New Year's Day (observed) # Two different ways to defined MLK day third Monday in Jan = Martin Luther King Jr.'s Birthday # 1*1:3:1:0:0:0 = Martin Luther King Jr.'s Birthday # Observed by federal employees in Washington D.C. # Jan 20 = Inauguration day third Monday in Feb = Washington's Birthday last Monday in May = Memorial Day 1st Monday in Sep = Labor Day second Monday in Oct = Columbus Day # Jul 4 = Independence Day 1*7:0:4:0:0:0*DWD = Independence Day # 11/11 = Veterans Day 1*11:0:11:0:0:0*DWD = Veteran's Day # To define both Thanksgiving and the day after, use the # following two lines: fourth Thu in Nov = Thanksgiving 1*11:4:4:0:0:0*FD1 = Day after Thanksgiving # Dec 25 = Christmas 1*12:0:25:0:0:0*DWD = Christmas # SAMPLE HOLIDAYS ################## # You can define a one-time-only holiday by specifying # the day and year. 6/2/1999 = A special test holiday for 1999 ################################ # EVENTS ################################ # See the Date::Manip::Holidays man page for a description of # this section. *EVENTS 2000-02-01 = Event01 2000-02-01-12:00:00 = Event02 02-01 = Event03 02-01 12:00:00 = Event04 1*2:0:3:13:00:00 = Event05 2000-02-05 10:00:00 ; 2000-02-05 10:59:59 = Event06 2000-02-05 ; 2000-02-06 = Event07 02-05 ; 02-06 = Event08 2000-02-07 10:00:00 ; 0:0:0:0:3:0:0 = Event09 02-07 10:00:00 ; 0:0:0:0:4:0:0 = Event10 1*2:0:7:10:00:00 ; 0:0:0:0:5:0:0 = Event11 SEE ALSO
Date::Manip - main module documentation LICENSE
This script is free software; you can redistribute it and/or modify it under the same terms as Perl itself. AUTHOR
Sullivan Beck (sbeck@cpan.org) perl v5.16.3 2014-06-09 Date::Manip::ConfigFile(3)
All times are GMT -4. The time now is 04:26 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy