I have an ENUMLIST storing data as expected. I use SUBSTITUTE to put it into the clients format but when the data is exporting to csv it distributes across columns (due to the comma) when it should stay in one single field.
I tried wrapping it in another set of commas but appsheet doesnโt like the expression.
โ^โ&SUBSTITUTE([BIN Refurb Type],",","^,^")&"^"
How can I get the data to appear only in the single field vs. parsed out? A million thanks
Need this:
Getting This:
Hmmmโฆ Iโd call that a deficiency in the CVS exporter. It should be smart enough to handle data with significant punctuation like that.
Maybe try wrapping like this instead:
'"' & SUBSTITUTE([BIN Refurb Type], ",", "^,^") & '"'
Got it. Will give it a try and report back
Hey Steve it worked! just had to add the ^ at the beginning and end.
Thanks Steve
User | Count |
---|---|
42 | |
27 | |
25 | |
20 | |
13 |