0
Completed

Text Delimiter Support for Reading CSV

GianPiero 9 years ago in Studio / Toolbox updated by Gandalf 9 years ago 0

Hi guys, would it be possible to introduce text delimeted support for reading CSVs?

For example, let's say I have the following CSV:


'Big,Branch','1','false' 

'Small Branch','2','true'

'Smallest Branch','1','false'


The CSV is comma separated and text delimited. When I split it however using WareWolf, the Big and Branch in the first line are being split because there is a comma between the 2 words.  If I could specify a text delimiter then this wouldn't be a problem.


This is a common occurrence for us, as Excel tends to use Text Delimiters when saving Excel files to CSV. Could this be added for us?

Answer
Gandalf 9 years ago

This is a great usage scenario.

You can achieve this quite simply:

As each header/field etc from the file has its own row to describe how it is split and the characters to split on can be verbose you can do this 


and then repeat the pattern as you see fit.

Also, the large view for the tool (which should be out soon!) has the ability to specify an escape character if you need it.

0
Completed

Tool short cut keys

Chas Digal 9 years ago in Studio / Toolbox updated by Gandalf 7 years ago 3

It would be great to have some short cut keys for each tool, or some custom keys that can be assigned. When you are working on the design surface, the slow part is finding the tool you want in the toolbox.

designer tool
Answer
Gandalf 7 years ago

Great thinking.