从CSV中剥离额外文本限定符 [英] stripping extra text qualifier from a 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中剥离额外文本限定符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！