Categories
View Replies (10)

Resolved Regular Expression = Remove numbers from field

  1. erStaranta
    erStaranta
  2. RO CSVI
  3. Monday, 04 April 2016
  4.  Subscribe via email
Hello,

I have a code like that:
1450XL

I need to have only XL.

The rules I did is this:
Replace
Regular Expression
Find: /[^A-Za-z]+/
Replace: $1

I'm sure that I'm wrong, can you help me please?


Thanks a lot in advance!
0
Responses (10)
rolandd
rolandd
Accepted Answer Pending Moderation
You need to update your regular expression, not a CSVI bug.

Your regular expression says to match everything but 0-9. Apparently you don't want to match the | symbol as well, so you should add that after the 9. That should fix it.
Kind regards,

RolandD

=========================
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
erStaranta
erStaranta
Accepted Answer Pending Moderation
Follow my previous example, the result after the rule is:

500541
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Ok, that is clear but what is the result after applying the replacement rule?
Kind regards,

RolandD

=========================
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. # 3
erStaranta
erStaranta
Accepted Answer Pending Moderation
Sure, you find it in attachment.

With this rule I need to remove letters from a sku that is like that:

500|541a
Attachments (1)
rules.png rules.png
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Show me how you have setup the replacement rule, so I can check it.
Kind regards,

RolandD

=========================
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. # 5
erStaranta
erStaranta
Accepted Answer Pending Moderation
Hello,

just tried, but it's not working...

Do you have a solution, please? Thanks a lot!
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The pipe-symbol is reserved for multiple values unless you specify another one in your replacement rule settings. You can change the multiple values indicator there. Did you try that?
Kind regards,

RolandD

=========================
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. # 7
erStaranta
erStaranta
Accepted Answer Pending Moderation
If I have a simbol like this: |

With the regular expression it is removed, how can I exclude it to the regular expression?
I need to have the | in the field, thanks.


Thanks a lot!
  1. more than a month ago
  2. RO CSVI
  3. # 8
erStaranta
erStaranta
Accepted Answer Pending Moderation
Thank you very much!
  1. more than a month ago
  2. RO CSVI
  3. # 9
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Since you are looking for replacing numbers, your expression should be Find: /^[0-9 ]+/ and leave the Replace field empty and see if it works.
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. # 10
  • Page :
  • 1


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