Sponsored Content
Full Discussion: Formatting a text file
Top Forums Shell Programming and Scripting Formatting a text file Post 302936077 by Chubler_XL on Sunday 22nd of February 2015 09:15:55 PM
Old 02-22-2015
Try this, if you're happy with the result then use mv infile.fixed infile to overwrite the original with the updated version.

Code:
awk 'NF==2 {
   printf "%s ", tolower($1)
   cnt=split(tolower($2),users,",");
   for(u=1;u<=cnt;u++) printf " (,%s,)", users[u]
   printf "\n"
}' infile > infile.fixed

Or this using bash script:

Code:
#!/bin/bash

while read group users
do
   printf "$group"
   ( IFS=,
     for user in $users
     do
       printf " (,$user,)"
     done
   )
   printf "\n"
done < infile > infile.fixed


Last edited by Chubler_XL; 02-22-2015 at 10:26 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

text file formatting by perl

have a simple text file as input.i have to print that file in paragraph format.whenevr it finds "\n" in the input text it should start printing in next paragraph in output file.also a fixed amount of space should be given before start writing in every paragraph. the input and output file format... (5 Replies)
Discussion started by: avik1983
5 Replies

2. Shell Programming and Scripting

Formatting a text file based on newline and delimiter characters

Hi Everybody, I need some help on formatting the files coming into unix box on the fly. I get a file some thing like this in a single line. ISA^M00^M ^M00^M ^M14^M006929681900 ^M01^M095449419 ... (5 Replies)
Discussion started by: ntekupal
5 Replies

3. UNIX for Dummies Questions & Answers

Text file formatting

Hi all! I'm new in unix, and faced with some difficulties. So I have text file f.e. "textfile" which contains rows like: aaa bbb ccc ddd How could I format it, so the file looks like: aaabbb cccddd Thanks in andvance (5 Replies)
Discussion started by: consta.v
5 Replies

4. UNIX for Dummies Questions & Answers

formatting of the text file

Hi Guys, I have a file with contents in the below format DO_VJ_IDOC;03.23.2009;22:31:09; ZJDO_VJ_IDOC;03.23.2009;22:46:14; ZJDO_RESEND_FAILURES;03.24.2009;01:46:18; Now i need to replace the semicolons with tabs for which i am usig the sed command which gives the O/p as below ... (1 Reply)
Discussion started by: rohit.shetty84
1 Replies

5. Shell Programming and Scripting

Formatting a text file to get data in exact line by line

I have my data something like this SERIAL FIRSTOCCURRENCE NETPROTOCOL 1947430693 07/01/2009 05:16:40 FR SERIAL FIRSTOCCURRENCE NETPROTOCOL 1947430746 07/01/2009 05:18:05 FR I want the output as follows.... (1 Reply)
Discussion started by: rdhanek
1 Replies

6. Shell Programming and Scripting

Formatting text file in unix

Hi, I am using the following format command for formatting my text file in unix. awk -F":" '{ printf "%-50s%-1s%-50s\n", $1,":", $2}' filename > targetfile The target file is then sent as an attachment via email. When I view the target file in notepad multiple lines get spanned as a... (2 Replies)
Discussion started by: AAA
2 Replies

7. Shell Programming and Scripting

Formatting the text file using shell script

How to add the filename to end of each line with | as seperator, except first and last line of the file(s) in directories(with diff tree structure) using shell script?. And also how to replace a list of strings with another set of strings, which is present in a file?. Kindly help out on... (1 Reply)
Discussion started by: av_vinay
1 Replies

8. Shell Programming and Scripting

Comparing and Formatting the text file

hi, I need a script which can format the below text file which contains comments file1.txt -------- //START //Name: some value //Date: //Changes:............. //..................... //END //START //Date: //Name: some value //Changes:............. //..................... (3 Replies)
Discussion started by: flamingo_l
3 Replies

9. Shell Programming and Scripting

[Solved] Formatting the text file

Hi All, I ahve requirement where I want to put the text file in into proper format. I am wondering how can i achieve that:- Host/Alias Name IP Address Resolved sinuiy01.infra.go2uti.com 10.240.8.158 N sinuid20.devtst.go2uti.com 10.240.8.230 N sinuid21.devtst.go2uti.com... (6 Replies)
Discussion started by: sharsour
6 Replies

10. Shell Programming and Scripting

Formatting text file

Hi All, how to format text Thanks (19 Replies)
Discussion started by: ROCK_PLSQL
19 Replies
KICONV(3)						   BSD Library Functions Manual 						 KICONV(3)

NAME
kiconv_add_xlat16_cspair, kiconv_add_xlat16_cspairs, kiconv_add_xlat16_table -- kernel side iconv library LIBRARY
Kernel side iconv library (libkiconv, -lkiconv) SYNOPSIS
#include <sys/iconv.h> int kiconv_add_xlat16_cspair(const char *tocode, const char *fromcode, int flag); int kiconv_add_xlat16_cspairs(const char *foreigncode, const char *localcode); int kiconv_add_xlat16_table(const char *tocode, const char *fromcode, const void *data, int datalen); DESCRIPTION
The kiconv library provides multi-byte character conversion tables for kernel side iconv service. The kiconv_add_xlat16_cspair() function defines a conversion table using iconv(3) between fromcode charset and tocode charset. You can spec- ify flag to determine if tolower(3) / toupper(3) conversion is included in the table. The flag has following values. KICONV_LOWER KICONV_FROM_LOWER It generates a tolower table in addition to a character conversion table. The difference between two is tolower tocode or tolower fromcode. KICONV_UPPER KICONV_FROM_UPPER It generates a toupper table in addition to a character conversion table. The difference between two is toupper tocode or toupper fromcode. A tolower/toupper conversion is limited to single-byte characters. The kiconv_add_xlat16_cspairs() function defines two conversion tables which are from localcode to foreigncode and from foreigncode to localcode. These conversion tables also contain both tolower and toupper tables. The kiconv_add_xlat16_table() function defines a conversion table directly pointed by data whose length is datalen, not using iconv(3). SEE ALSO
iconv(3), tolower(3), toupper(3) BSD
July 17, 2003 BSD
All times are GMT -4. The time now is 06:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy