开发者

Changing field separator

开发者 https://www.devze.com 2023-02-18 20:28 出处:网络
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?

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

精彩评论

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