How do I get a snippet to insert a character only if the user typed something?

Question

I have this snippet.

SELECT 'SELECT * FROM ' + OBJECT_SCHEMA_NAME(o.object_id, DB_ID(${20:})) + '.' + name,
       *
FROM ${20/$/./}sys.all_objects o
WHERE name LIKE '%${10:hadr}%'
ORDER BY o.name;

And this is how it works:

When the user types something in the function DB_ID(), I hope the content the user typed appears before sys.all_objects AND append an additional .. It already works like this as it shown in the above gif. However, I also hope if the user types nothing in the function DB_ID(), don't add . before sys.all_objects. Is this possible?

If you have snippet code already, you should show what you have. — Mark
– Mark, Commented Jan 22, 2023 at 3:20
Please write a more descriptive title, maybe something like, "How do I get a snippet to insert a character only if the user typed something?" Check out How to Ask for tips on how to write a good title. — wjandrea
– wjandrea, Commented Jan 22, 2023 at 3:26
It'd help to make a minimal reproducible example. You can copy the one from my answer if you want. — wjandrea
– wjandrea, Commented Jan 22, 2023 at 3:33

rioV8 · Accepted Answer · 2023-01-22 11:03:50Z

2

No need to add the : in field 2:

DB_ID(${2})

Use field 2

${2/(.*)/$1${1:+.}/}

capture all the typed text: (.*)
replace it with all the typed text: $1
followed by a . if the typed text is not empty: ${1:+.}

answered Jan 22, 2023 at 11:03

rioV8

29.7k4 gold badges48 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

wjandrea · Accepted Answer · 2023-01-22 03:32:33Z

1

You can use lookbehind to assert that there's something in that field: (?<=.)$. For a minimal example, let's say this is the original snippet:

foo($1); ${1/$/./}bar()

Change it to:

foo($1); ${1/(?<=.)$/./}bar()

If I type something, e.g. x, then press Tab, I get:

foo(x); x.bar()

If I don't type anything then press Tab, I get:

foo(); bar()

answered Jan 22, 2023 at 3:32

wjandrea

33.8k10 gold badges69 silver badges105 bronze badges

Collectives™ on Stack Overflow

How do I get a snippet to insert a character only if the user typed something?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related