本文介绍了从CSV中剥离额外文本限定符的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
请注意,每个整数(例如1,2 ,3 etc)应该是一个字符串,合格的字符串被符号包围。
1,2,3 ,qualifiedString1,4,5,6,7,8,9,10,11,12,13,14,15,16,qualifiedString2
注意最后一个合格的字符串是否有一个符号作为字符串的一部分。
自动清除CSV以消除冗余的限定符?
我可以使用以下技术:POSH / BAT脚本,VBA,Access。 >
解决方案
这样可能吗?
(get-content file.txt -ReadCount 0)-replace'([^,])','$ 1'|
set-content newfile.txt
I have a CSV that has certain fields separated by the " symbol as a TextQualifier.
See below for example. Note that each integer (eg. 1,2,3 etc) is supposed to be a string. the qualified strings are surrounded by the " symbol.
1,2,3,"qualifiedString1",4,5,6,7,8,9,10,11,12,13,14,15,16,"qualifiedString2""
Notice how the last qualified string has a " symbol as part of the string.
Can you suggest an elegant way to automate the cleaning of the CSV to eliminate redundant " qualifiers?
I have the following technologies at my disposal: POSH/BAT scripting, VBA, Access.
解决方案
Something like this, perhaps?
(get-content file.txt -ReadCount 0) -replace '([^,]")"','$1' |
set-content newfile.txt
这篇关于从CSV中剥离额外文本限定符的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!