Ideas
Text Delimiter Support for Reading CSV
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
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.
Customer support service by UserEcho
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.