I usually have to collect hundreds of keywords from different websites for my YouTube descriptions. The problem is that they are always in a long vertical list. Copy-pasting them one by one and adding commas manually takes almost 15-20 minutes every time. Does anyone know a "jugaad" or a tool that can join these lines instantly?
How to convert multi-line lists into single-line CSV or Hashtags quickly?
Verified
I usually have to collect hundreds of keywords from different websites for my YouTube descriptions. The problem is that they are always in a...
Comments (7)
How to convert multi-line lists into single-line CSV or Hashtags quickly?
1. Paste your list in the box.
2. In the "Join with" dropdown, select Space.
3. Look for the Add Prefix box and type # there.
4. Click the Join Text button.
Now all your words will have a hashtag and will be in one single line.
Example for SQL/Programming:
1. Input:
Apple
Samsung
Vivo
2. Settings:
Prefix: '
Suffix: '
Separator: Comma ( , )
3. Output:
'Apple','Samsung','Vivo'
This is exactly what you need for your array. Tip: Make sure 'Trim spaces' is turned ON to avoid errors.
Example for Cleaning Messy Data:
1. Input:
abc@gmail.com
xyz@yahoo.com
abc@gmail.com (Duplicate)
2. Settings:
Turn ON Ignore empty lines
Turn ON Remove duplicate items
3. Output:
abc@gmail.com,xyz@yahoo.com
It automatically removes the extra space and the duplicate entry.Try It Yourself