Remove Quotations CSV

[WhiteBoyCat]

I am using CVSLib.au3 and taht is a GREAT! Include for Autoit. It has so many great functions. But there is one problem I am facing. With excel it adds quotation marks as escape characters for example: "Spanish, Chris"

I am trying to automate filling and I need the name only. So How do I remove the quotation marks around this name?

The problem is: it is not always the case that I have to remove the quotation marks.

How do I make a check to See if there are quotation marks and remove them if their are?

[water]

Something like this. When the first character is a quotation I assume that the tring is quoted.

$sName = '"Spanish, Chris"'
ConsoleWrite("Before: " & $sName & @CRLF)
If Stringleft($sName,1) = '"' Then $sName = StringMid($sName,2,Stringlen($sName)-2)
ConsoleWrite("After: " & $sName & @CRLF)

It could be done with regular expressions using function StringRegExprReplace as well but I'm not familiar with SRE.

Edited June 6, 2011 by water

[Ascend4nt]

Assuming there's no whitespace before/after, you can use this (or add in \s* where necessary):

$sStr='"Spanish, Chris"'
$sStr=StringRegExpReplace($sStr,'(^"|"$)','')

[WhiteBoyCat]

Sweet thanks for the advice.

[VertigoRay]

On 6/6/2011 at 2:11 PM, 'Ascend4nt said:

Assuming there's no whitespace before/after, you can use this (or add in s* where necessary):

$sStr='"Spanish, Chris"'
$sStr=StringRegExpReplace($sStr,'(^"|"$)','')

$sStr=StringRegExpReplace($sStr,'^[ ]*"|"[ ]*$','')

This will get the whitespace you're talking about. Also, no point in wasting cycles on capturing if you're not doing anything with it.

Cheers!

Note: I realize this post is old, but I wanted to post an alternative regex solution to the one provided.

Edited January 8, 2018 by VertigoRay

[Nessie]

$sStr=StringRegExpReplace($sStr,'^[ ]*"|"[ ]*$','')

This will get the whitespace you're talking about. Also, no point in wasting cycles on capturing if you're not doing anything with it.

Cheers!

I think he already solved his problem

Hi!

[refack]

$f = StringRegExpReplace($f,'^[ "]*|([^\\])[ "]*$','\1')

In cases where the string is a path, we should consider the case where the last `"` is escaped...