开发者

Changing field separator

I can see that using maatkit I can export the data as comma or tab separated values. But is there anyway to change the field separator?

http://www.maatkit.org/doc/mk-parallel-dump.html

I have a table that has comma as well as tabs in the data. Besides I need to process the data using awk that does not seem to work with certain fields data. I want to change the s开发者_如何学JAVAeparator while dumping data using maatkit. Is it possible?


Commas present in data should not cause any problem: the text fields (and maybe all fields) are within quotes:

"field 1 value", "field 2 value", 3.38823, "field 4 value"
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜