Add single quote and comma
-
How can I add single quote and comma for each of the sequence no and also how can I get this on a column like this
actual data: 12345 56789 23456 56789 56789preference 1: ‘12345’, ‘56789’, ‘23456’, ‘56789’, ‘56789’
preference 2:
12345
56789
23456
56789
56789Thanks for sharing your knowledge.
-
@chin-pat said in Add single quote and comma:
How can I add single quote and comma for each of the sequence no and also how can I get this on a column like this
To get this:
‘12345’, ‘56789’, ‘23456’, ‘56789’, ‘56789’
use the following regular expression in the Replace function (search mode is regular expression). Note the single quote isn’t what you show in the post, verify I have the correct one as the posting engine does change quotes when not inside the black boxes (se the</>icon to encapsulate examples)
Find What:\d+(?=(\x20)|$)
Replace With:'$0'(?1,)To get this
12345
56789
23456
56789
56789
use the following regular expression
Find What:\x20
Replace With:\r\nTerry
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login