Search Results

"2007-09-09","1-71J-1","2004-03-20 12:00:59","0-1","2006-01-16 17:27:19","1-2RRYX-6","N","xuwedong",,"xwd",,,,,,"tv","Mr.","No Match Row Id","mail","111111111",,"+8610666666",,"rmrb","^M
Building B...

Source data file from oracle, terminated by ",". 'Cause some of fields have \r\n, then those lines were splitted into multiple lines in the expoted data file. Just vi this file, and found ^M. How to...

This works fine, but performance is poor.

Could we use regular expression for awk -F to differentiate unquoted commas?

Help!
Please give me a solution.

format of "x1,2" can be at any place.

Yes.

This is a general question. How to differentiate , in the double-quoted text string from delim.

thanks,

Acutually, ",," means there is a null value for this field. As for "x1,2",,"y",,,"z",,,
1,3,and 6 has value while other fields are null. So I think ,, cannot be the delim.

"x1,2",,"y",,"z" is just an example of the format. what if "x1,2",,"y",,,"z",,,?

select some fields from data file (source.csv)
The data in file(source.csv) is like
"x1,2",,"y",,"z"

How to get the 1st, 2nd and 3rd field from the file. Using awk or cut?

Note: "x1,2" is one...

use "getopts" to get params from command. Need replace black with a specified string like "%20

DEFAULT_DELIM＝％20
...
while getopts dek:f:t:vh OPTION
do
case $OPTION in
t)...