Format text output

07-20-2017

Registered User

2,100, 402

Join Date: Apr 2009

Last Activity: 11 February 2020, 10:24 AM EST

Posts: 2,100

Thanks Given: 26

Thanked 402 Times in 360 Posts

Quote:

Originally Posted by nms

...
...
I tried to play a bit with grep and awk, but i don't want to specifically grep any string from the first row since they may increase by time, making the grep static (i.e. by time the script needs to be altered to add the new string in grep.
can you kindly shed some light?

It looks like you have to perform the same set of steps on each line.

Take, for example, this line:

Code:

 201502-b31s31i10            | MVNO          | 114751 | 2017-07-19

1) Split it on the "|" character, to get the following tokens:

Code:

Token 1 = "201502-b31s31i10"
Token 2 = "MVNO"
Token 3 = "114751"
Token 4 = "2017-07-19"

2) Now use tokens 1, 3 and 4 to form this string:

Code:

201502-b31s31i10 - 114751 (2017-07-19)

3) And append it to another "output" string (i.e. a string that you will print once you are done processing your entire file.)

Keep doing steps 1), 2) and 3) for all lines you go through.
In the end, print the "output" string.

Here's a Perl implementation, in case Perl is an option for you.
The -F modifier specifies the character "|" to split the line on.

Code:

$
$ cat data.txt
 201502-b31s31i10            | MVNO          | 114751 | 2017-07-19
 201502-b31s31i10R60-60 | MVNO          |  62115   | 2017-07-19
 201511-b31s31i15            | MVNO          | 311970 | 2017-07-19
 Simpel PostPay                 | MVNO          |     59     | 2017-07-19
 Simpel PrePay                   | MVNO         |  10254   | 2017-07-19
$
$
$ perl -F/\\\|/ -lane '($x,$y,$z) = map {s/^\s*//; s/\s*$//; $_ } @F[0,2,3];  # trim whitespaces from tokens 0, 2, 3
                       $s .= "$x - $y ($z), ";                                # append trimmed tokens to output string
                       END {
                           $s =~ s/, $//;                                     # trim unnecessary characters from output
                           print $s
                       }
                      ' data.txt
201502-b31s31i10 - 114751 (2017-07-19), 201502-b31s31i10R60-60 - 62115 (2017-07-19), 201511-b31s31i15 - 311970 (2017-07-19), Simpel PostPay - 59 (2017-07-19), Simpel PrePay - 10254 (2017-07-19)
$
$

durden_tyler

View Public Profile for durden_tyler

Find all posts by durden_tyler

Shell Programming and Scripting

Format text output

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Loop to convert text output in the HTML format

Discussion started by: rahul2662

2. Shell Programming and Scripting

Format output

Discussion started by: H squared

3. Shell Programming and Scripting

Format with output

Discussion started by: aydj

4. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Discussion started by: dani1234

5. Shell Programming and Scripting

Read from text file;format and print output

Discussion started by: maddy.san

6. Shell Programming and Scripting

Need script for transferring bulk files from one format to text format

Discussion started by: Kranthi Kumar

7. Shell Programming and Scripting

Dynamic output file generation using a input text file with predefined output format

Discussion started by: hudson03051nh

8. Shell Programming and Scripting

How to format output

Discussion started by: uday542

9. Shell Programming and Scripting

capturing output from top and format output

Discussion started by: new2ss

10. Shell Programming and Scripting

format output

Discussion started by: Tornado