×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

@Florida

ok. i have another one. it is little bit harder. about csv file re-orginze.

647i(流浪的步行万里)
CSV file is well known MS access and Excel file extract. .csv file use CR/LF as record delimiter and ',' as field delimiter. Normally, the value of the field doens't cotnain either CR nor LF. In case when the value is not key in but copy/paste from other source. CR/LF may contains as field value. To mark it as a field, .csv file quote the field value with '"'.

Here is an example(4 columns)
1,bb,33,55
2,"a
c",66,88
3,aa,xx,kk
4,"Y
YY", dd, "ffff
kk"



All togher there are 4 lines, the first field is record number.

The requirement is:
Replace CR/LF by a space, if it is part of the field value. The following is the result after fix:

1,bb,33,55
2,"a c",66,88
3,aa,xx,kk
4,"Y YY", dd, "ffff kk"

Hint, I used sed to do the fix with N command.
(#3651939@0)
Last Updated: 2007-5-3
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / 专业技术讨论 / 贴个unix shell环境的小题目给大家玩玩儿。 输入变量为一不超过１０位的整数。要求输出值在输入值pad leading zero to make the length to 10. 看看谁的办法最简洁。 要求：不用使用文件，可以使用管道（pipe). -647i(流浪的步行万里); 2007-5-3 {357} (#3651153@0)
    my solution is: 
    
outvar=`echo $invar|sed -e 's/\(^.$\)/000000000\1/' -e 's/\(^..$\)/00000000\1/' -e 's/\(^...$\)/0000000\1/' -e 's/\(^....$\)/000000\1/' -e 's/\(^.....$\)/00000\1/' -e 's/\(^......$\)/0000\1/' -e 's/\(^.......$\)/000\1/' -e 's/\(^........$\)/00\1/' -e 's/\(^.........$\)/0\1/'`
    • how about -- printf "%.10d" $invar -onboard(Write it down); 2007-5-3 (#3651221@0)
      • en. good, better than mine: outvar=`echo $invar|awk '{printf("%.10d", $1)}'` -647i(流浪的步行万里); 2007-5-3 (#3651255@0)
        • what's the prize? ^_^ -onboard(Write it down); 2007-5-3 (#3651267@0)
          • en... u can ask. -647i(流浪的步行万里); 2007-5-3 (#3651285@0)
            • 那就再来一道吧...:D -onboard(Write it down); 2007-5-3 (#3651305@0)
              • ok. i have another one. it is little bit harder. about csv file re-orginze. -647i(流浪的步行万里); 2007-5-3 {790} (#3651939@0)
                CSV file is well known MS access and Excel file extract. .csv file use CR/LF as record delimiter and ',' as field delimiter. Normally, the value of the field doens't cotnain either CR nor LF. In case when the value is not key in but copy/paste from other source. CR/LF may contains as field value. To mark it as a field, .csv file quote the field value with '"'.

                Here is an example(4 columns)
                1,bb,33,55
                2,"a
                c",66,88
                3,aa,xx,kk
                4,"Y
                YY", dd, "ffff
                kk"



                All togher there are 4 lines, the first field is record number.

                The requirement is:
                Replace CR/LF by a space, if it is part of the field value. The following is the result after fix:

                1,bb,33,55
                2,"a c",66,88
                3,aa,xx,kk
                4,"Y YY", dd, "ffff kk"

                Hint, I used sed to do the fix with N command.
              • it looks this time no more prize ;) -647i(流浪的步行万里); 2007-5-3 (#3652503@0)
                • Couldn't google an answer this time :( 作为惩罚就再来一道吧...:D -onboard(Write it down); 2007-5-4 (#3652969@0)
                  • It is your turn now. 作为惩罚you来一道吧 -647i(流浪的步行万里); 2007-5-4 (#3653179@0)
    • 太复杂。转成string后，前面加10个0，然后取右边10位就行了。 -bdbs(不多不少); 2007-5-3 (#3651319@0)
      • 回得太快了，没看到楼上的解答。：） -bdbs(不多不少); 2007-5-3 (#3651323@0)

More Topics

  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
  • Elon Musk 带着川普总统奔向火星了。
  • 扔硬币的实验研究
    • 枫下论坛主坛 /  工作学习 /  专业技术讨论