comma-text conversion

[rgonzalez]

Hello, I'm using Windows 10 (just upgraded) and Office 2013 and I'm having a problem trying to use a Comma-text conversion since robotask takes spaces as delimiters if they are not enclosed by quotes.

This is an example of a file that I want to export to csv from excel 2013

1.PNG (3.19 KiB) Viewed 14848 times

This is the file opened in notepad

2.PNG (3.67 KiB) Viewed 14848 times

Theres no quotes added to columns with spaces, this didn't happen when I was using Windows 7 and Office 2013.

And my list separator on regional options is the same as before (a comma)

Code: Select all

,

Is there a way to tell robotask not to take spaces as list separator or a way to force excel to add quotes to columns with spaces?

Thank you.

[Oleg]

You can convert your string to standard comma-separated string by using Delimit variable action

Also see my example:

Code: Select all

;*****************************
;* RoboTask Task file
;* Do not edit in text editor!
;*****************************
 
[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|379259420
Comment=STRINGLIST
ContinueOnError=INTEGER|0
ExternalName=STRING|"Task10"
Hide=INTEGER|0
ID=INTEGER|15394252
LogOnAsUser=INTEGER|1
Name=STRING|"Convert to standard comma separated"
OnErrorTaskID=INTEGER|-1
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3
WriteGeneralLog=INTEGER|0

[Actions]
Action1=FOLDER
Action2=FOLDER
Action3=FOLDER
Action4=FOLDER

[Actions\Action1]
ActionID=STRING|"A_VARIABLES_SET"
Enabled=INTEGER|-1
Name=STRING|"Set variable ""TEXT"" with value ""rafa rafa,123,rafa rafa rafa,456,""rafa,rafa"""""
Params=FOLDER

[Actions\Action1\Params]
expand=STRING|"0"
varname=STRING|"TEXT"
varvalue=STRING|"rafa rafa,123,rafa rafa rafa,456,""rafa,rafa"""

[Actions\Action2]
ActionID=STRING|"A_DIALOG_MESSAGE"
Enabled=INTEGER|-1
Name=STRING|"Show ""{text}"""
Params=FOLDER

[Actions\Action2\Params]
icon=STRING|"1"
msg0=STRING|"{text}"
msg1=STRING|"********************"
msg2=STRING|"{text(0)}"
msg3=STRING|"{text(1)}"
msg4=STRING|"{text(2)}"
msg5=STRING|"{text(4)}"
msg6=STRING|"{text(5)}"
msgcount=STRING|"7"
playsound=STRING|"0"
showmessage=STRING|"1"

[Actions\Action3]
ActionID=STRING|"A_VARIABLES_DELIMITED"
Enabled=INTEGER|-1
Name=STRING|"Delimit Variable"
Params=FOLDER

[Actions\Action3\Params]
colon=STRING|"0"
comma=STRING|"1"
other=STRING|"0"
quote=STRING|"0"
semocolon=STRING|"0"
space=STRING|"0"
spaceasone=STRING|"0"
string=STRING|"{text}"
tab=STRING|"0"
variable=STRING|"text"

[Actions\Action4]
ActionID=STRING|"A_DIALOG_MESSAGE"
Enabled=INTEGER|-1
Name=STRING|"Show ""{text}"""
Params=FOLDER

[Actions\Action4\Params]
icon=STRING|"1"
msg0=STRING|"{text}"
msg1=STRING|"*****************"
msg2=STRING|"{text(0)}"
msg3=STRING|"{text(1)}"
msg4=STRING|"{text(2)}"
msg5=STRING|"{text(4)}"
msg6=STRING|"{text(5)}"
msgcount=STRING|"7"
playsound=STRING|"0"
showmessage=STRING|"1"

[rgonzalez]

Thank you! This works great!