Shell Programming and Scripting

Hi mjf,

Do you have any idea regarding "write an Excel formula or some VBA code to handle the underlining part" that you mention?

Sorry that I lack of experience when dealing with this type of data set

I'd be very surprised if you get the EXCEL formatting into a plain text file. If you do, please keep me informed!
What you can do is insert terminal/console control chars into your text. See man console_codesExample (use editor of choice):

Code:

$ cat -v file
provider ^[[4m   telecom   ^[[0m -view ...
          ^---underline on  ^--- reset = no ul

The ^[ in each "escape sequence" is the <ESC> char (ASCII 27, 0X1B, \033). Try to print above sequence to your terminal and see...

If you choose the Excel route, here is an "untested" example of how to do such using VBA in Excel:

If cell A1 contains the starting point, cell B1 contains the ending proint and
the string is in cell C1 (your active cell), then underline that range.

Code:

 
ActiveCell.Characters(A1,B1).Font.Underline = True

　
There is a bit more to it then that but that's for another forum.

With your sample file from post#1:

Code:

awk     'BEGIN {ULON="\033[4m"; RST="\033[0m"}
               {$3 = substr($3,1,$1-1) ULON substr($3,$1,$2-$1+1) RST substr($3,$2+1)}
         1
        ' file
2 5 ASFGEWTEWRQWEQ
10 20 QEWIORUEIOUEWORUQWEQWRQRQWGQWGFQ
1 6 WRQTQWTQTQWTQT

You can't see the underline in this post; try on a terminal.

Hi RudiC,

Sorry for misleading.
I should said that I save a file in *.txt format and I used microsoft excel to open the *.txt.
After then, manual underline the region of interest previously.

Do you mind to share more how to underline or bold my content in terminal?
I did try your method, but it seems like can't work.
Maybe I misunderstanding your command

Below is my input file:
Part of long list of Input file

Code:

3 10 QWETRQWTQWRQWEQEQGTQWTQGTQWTRQWGTQWERQW

Desired output

Code:

3 10 QWETRQWTQWRQWEQEQGTQWTQGTQWTRQWGTQWERQW

"ETRQWTQW" should be underline automatic by your program/script if possible.

Many thanks.

---------- Post updated at 09:44 AM ---------- Previous update was at 09:36 AM ----------

Hi RudiC,

Many thanks for reply.
I have a try by using Ubuntu terminal then.

Thanks a lot.
I will update you once the result is out.

Hi RudiC,

After I try your awk command, it able to shown underline of region interest through terminal.
However when I open those *.txt by Microsoft Excel or Notepad.
It shown some "SFGE[0mE" rather than shown underline at region interested.

My main purpose was hope that able to figure a way or method that able to underline region interest and it able to shown when I open through Microsoft Excel.

Thanks a lot and again.

You did not mention to use EXCEL in your specification. EXCEL is showing exactly what you put in: the console code to switch underline on, the text, the code to switch ul off.
EXCEL underline and terminal underline are two completely different and incompatible things.

Still you may code a VBA script to turn the console codes to sth EXCEL understands...