Separate a numeric value from a string
Tell me, there is a field with the value "CsCart#1071" how can I leave only the number "1071" in this field or write it in another field?
Are there any actions that support string functions? Replacing values, splitting or trimming strings?
Original question is available on version: ru
Are there any actions that support string functions? Replacing values, splitting or trimming strings?
Answers:
Perhaps this action with a checkmark is suitable for you http://i.imgur.com/mE2ldF0.png
then you can use PHP functions http://i.imgur.com/pd6FYBz.png
I don't know exactly what function to use.
Then you need to specify in the action the field in which the number will be written, and in the formula line the desired operation on the field with the value "CsCart#1071"
then you can use PHP functions http://i.imgur.com/pd6FYBz.png
I don't know exactly what function to use.
Then you need to specify in the action the field in which the number will be written, and in the formula line the desired operation on the field with the value "CsCart#1071"
02.10.2020, 09:50
Original comment available on version: ru
Ivan, thanks - it helped!
Perhaps it will be useful to someone in order for the action to work, you need to insert the variable in quotes, which is not very logical, if you insert it without quotes, it will give an error. In my case, the formula worked: trim('[cscartbp30]','CS-Cart #')
Perhaps it will be useful to someone in order for the action to work, you need to insert the variable in quotes, which is not very logical, if you insert it without quotes, it will give an error. In my case, the formula worked: trim('[cscartbp30]','CS-Cart #')
02.10.2020, 11:22
Original comment available on version: ru
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
