when I have to export products I have often the problem that there are linebreaks in the decriptions and short descriptions.
This linebreak is also in the csv so that prouct datas will be splitted in serveral lines.
Im dreaming for a flag which gives me the possibility to remove all kinds of linebraks e.g.chr$(10), chr$(13) in textarea attributes like discription an short description.
Best
New
0 votes
Vote
Reply
4 Answers
Oct 20, 2015
Alex Pryshlivskiyagentwrote
Sorry, it's not clear.
Why do you need this option ?
In this case you'll get the following result
test1
test 2
test 3
After replace you'll get: "test1test 2test 3"
Oct 20, 2015
pixelmediawrote
I think two screenshots will explain it much better than my words :-)
Pardon, still not clear why do you need to remove formatting ?
:-(
Well. There are screenshots of export.
as a result - you'll be able to open exported CSV file in Calcs ...
Quick decision: You'll be able to import your exported file with special expression - replace
----------
Syntax:
REPLACE(str,from_str,to_str)
---------
OR var2 - you 'll be able to replace exported file with help of notepadby special symbols.
We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com
Maybe we are waiting for some information from your side? In this case please get back to us.
In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.
If you do not reply us back, the ticket will be automatically closed within 24 hours.