@CategoryL3 nvarchar(50), @CategoryL4 nvarchar(50),2) The sample from update statement
[CategoryL3]=@CategoryL3, [CategoryL4]=@CategoryL4,3) The sample from insert statement
[CategoryL3], [CategoryL4]and then:
@CategoryL3, @CategoryL4Here is regex to find things from first sample:
[@]{.[^@ ]*} .[^@ ]*,
- in {} brackets we get the expression we want to extract from what has been found.
I'm looking for:
- @ at sing
- ".[^@ ]* "- all the signs (.*) until space (which is after star) that don't contain @ sign
- then there is space and anything thats between this space and comma, but again without @ sign (to avoid greedy results) .[^@ ]*
then in replace with text box I can put \1 which result with setting it to the values I enclosed with curly brackets.
Brak komentarzy:
Prześlij komentarz