JasonKaufman
Programmer
I am needing to create a CSV file using a long description field that can be of various lengths and could look something like the following bold type:
bt boys basics gry 0-6 months
Product Testing Required-CPSIA Protocols-Lead in Substrates Section 101 CPSIA, Phthalates Section 108 CPSIA:
R3149 (Navy & White), H311-15, Pass, exp. 4/13/16
data data data data data data
When I export this field it remains looking like above and rather than being 1 line of data, it is multiple rows.
I need to have this data to be on the same row as the rest of the pulled product data.
Then have an indication in that extracted data for the carriage return when needed.
Final data would look like below (but without the wrapped text):
bt boys basics gry 0-6 months<CR><CR>Product Testing Required-CPSIA Protocols-Lead in Substrates Section 101 CPSIA, Phthalates Section 108 CPSIA:<CR>R3149 (Navy & White), H311-15, Pass, exp. 4/13/16<CR><CR>data data data data data data
where <CR> is the indicator (can certainly be different) for when a carriage return occurs.
Thanks!
bt boys basics gry 0-6 months
Product Testing Required-CPSIA Protocols-Lead in Substrates Section 101 CPSIA, Phthalates Section 108 CPSIA:
R3149 (Navy & White), H311-15, Pass, exp. 4/13/16
data data data data data data
When I export this field it remains looking like above and rather than being 1 line of data, it is multiple rows.
I need to have this data to be on the same row as the rest of the pulled product data.
Then have an indication in that extracted data for the carriage return when needed.
Final data would look like below (but without the wrapped text):
bt boys basics gry 0-6 months<CR><CR>Product Testing Required-CPSIA Protocols-Lead in Substrates Section 101 CPSIA, Phthalates Section 108 CPSIA:<CR>R3149 (Navy & White), H311-15, Pass, exp. 4/13/16<CR><CR>data data data data data data
where <CR> is the indicator (can certainly be different) for when a carriage return occurs.
Thanks!