CSV creation

  • Thread starter Thread starter musosdev
  • Start date Start date
M

musosdev

Hi

I've written some code to generate a CSV file from a database table.
However, some colums are getting broken up into 2 fields, or truncated - I
think cos they have comma in, and of course commas are used as field
seperators.

How can I ensure that my fields stay in tact?!

Thanks
 
Dans : musosdev écrivait :
Hi
Hello,

I've written some code to generate a CSV file from a database table.
However, some colums are getting broken up into 2 fields, or
truncated - I think cos they have comma in, and of course commas are
used as field seperators.

How can I ensure that my fields stay in tact?!
Click to expand...


According to the specifications I found (seems there is not a real
standard (?)) I use this little program in vb to escape the values.
separator is the chosen separator for the CSV file : a comma most of the
time
a value should be enclosed with quotes when :
- containing the separator
- containing line breaks
- containing quotes
- starting or ending with space

If strvalue.Contains(separator) OrElse _
strvalue.Contains(vbCrLf) OrElse _
strvalue.Contains(vbCr) OrElse _
strvalue.Contains(vbLf) OrElse _
strvalue.Contains("""") OrElse _
strvalue.StartsWith(" ") OrElse _
strvalue.EndsWith(" ") Then
strvalue = strvalue.Replace("""", """""")
strvalue = """" & strvalue & """"
End If
 
Back
Top