I confirmed that this is indeed a bug. If the CSV file is read, the abc\ndef
string is imported as abc\\ndef
(so two \ instead of one). => We will fix this asap.
Workaround: Replace each \\n
with \n
. You can do this with a regular expression:
var str = ${t1}; return str.replace(/\\n/g,"\n");
This macro works:
{
"Name": "csv2",
"CreationDate": "2021-4-20",
"Commands": [
{
"Command": "open",
"Target": "https://ui.vision/contact",
"Value": ""
},
{
"Command": "csvRead",
"Target": "testcsv",
"Value": ""
},
{
"Command": "store",
"Target": "true",
"Value": "!stringEscape"
},
{
"Command": "store",
"Target": "${!COL1}",
"Value": "t1"
},
{
"Command": "echo",
"Target": "${t1}",
"Value": "green"
},
{
"Command": "executeScript_Sandbox",
"Target": "var str = ${t1}; return str.replace(/\\\\n/g,\"\\n\");",
"Value": "t1b"
},
{
"Command": "echo",
"Target": "${t1b}",
"Value": "blue"
},
{
"Command": "type",
"Target": "id=Message",
"Value": "${t1b}"
}
]
}