Categories
View Replies (7)

Resolved export 'product_s_desc' without line breaks

  1. gametaxi
    gametaxi
  2. RO CSVI
  3. Monday, 31 October 2016
  4.  Subscribe via email
hello,

i need to export virtuemart product_s_desc without any line breaks, because its destroy the export file everytime.
my export template configuration:
Field Delimiter: ~
Text Enclosure: '

i tried also a replace rule to remove all html from the field. but i did not find a way to remove line breaks.

please can you help?
0
Responses (7)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You can try opening your export file with OpenOffice/LibreOffice as it interprets line breaks. See if it helps.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
One more solution here is that you can also try writing a replace rule using regular expression to find for \r\n and replace it with a space. Let me know if this helps.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
gametaxi
gametaxi
Accepted Answer Pending Moderation
if i try replace rule regular expression \r\n i get empty fields for 'product_s_desc'
same if i try only \r or \n
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I am not that good in writing regular expressions but can you post the screenshot of your replace rule to check?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
gametaxi
gametaxi
Accepted Answer Pending Moderation
screenshot
Attachments (1)
Unbenannt-2.jpg Unbenannt-2.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 5
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Regular expression is a pattern we use to find a string or a character or a numbers inside another string. Have a look at regex documentation to know on it. You have written a rule to find \r\n and replace it with space and the method to be regular expression. This explains why product_s_desc field was empty. You can try changing method to regular text in your rule settings and see if it helps else you would need to find a regular expression which would find line breaks and use it in your rule.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
gametaxi
gametaxi
Accepted Answer Pending Moderation
ok thanks for help. found the solution.
replacement find regular expression:
/\n/
  1. more than a month ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!