<div>
--ozo, Excellent!!!<br />
<br />
One small thing: <br />
<br />
In one of our servers, &nbsp;the command generated several extra characters below. I tried the different way to run it, but they stayed there. It seems normal to run the other commands on this server. Do you know what caused them?<br />
&nbsp;<br />
ï»¿10, Y2('100','CC'), A, Y2('200','CC'),C<br />
20, Y2('300','CC'),B, ,D<br />
30, Y2('400','CC'), Y2('500','CC'),F,G<br />
<br />
I tried to
</div>


--ozo, Excellent!!!

One small thing:

In one of our servers,  the command generated several extra characters below. I tried the different way to run it, but they stayed there. It seems normal to run the other commands on this server. Do you know what caused them?
 
ï»¿10, Y2('100','CC'), A, Y2('200','CC'),C
20, Y2('300','CC'),B, ,D
30, Y2('400','CC'), Y2('500','CC'),F,G

I tried to

<div>
run it on the other servers, it generated what I want. the shell on all servers are the same /bin/bash. Thanks.
</div>


run it on the other servers, it generated what I want. the shell on all servers are the same /bin/bash. Thanks.

<div>
As always, I greatly appreciated your constant help.
</div>


As always, I greatly appreciated your constant help.

<div>
<div class="content wysiwyg-content">
Have a file like the following:<br />
<br />
10, X1'100', A, X1'200',C<br />
20, X1'300',B, ,D<br />
30, X1'400', X1'500',F,G<br />
...<br />
Want to revise it to<br />
10, Y2'(100','CC'), A, Y2('200','CC'),C<br />
20, Y2('300','CC'),B, ,D<br />
30, Y2('400','CC'), Y2('500','CC'),F,G<br />
...<br />
That is to change any item like X1'100' to Y2('100','CC') with sed or awk, <br />
Please, can any gurus shed some light on it?<br />
Thanks in advance.
</div>
</div>


Have a file like the following:

10, X1'100', A, X1'200',C
20, X1'300',B, ,D
30, X1'400', X1'500',F,G
...
Want to revise it to
10, Y2'(100','CC'), A, Y2('200','CC'),C
20, Y2('300','CC'),B, ,D
30, Y2('400','CC'), Y2('500','CC'),F,G
...
That is to change any item like X1'100' to Y2('100','CC') with sed or awk, 
Please, can any gurus shed some light on it?
Thanks in advance.

change fields with sed or awk

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.

Shell Scripting

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.

Regular Expressions

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.