[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • Last Modified:

comma sep

Suppose I have a big list within a text file with out commas..
How will I give comma in between..

A
B
C
D


i do not have any application or nothing I can download for security reasons
0
tonydba
Asked:
tonydba
  • 3
  • 2
  • 2
  • +2
1 Solution
 
KimputerCommented:
For ease of you, you really need a program.
Option 1: Advanced editors like Notepad++. Use advanced find & replace:
find: \n\r
replace: ,

Option 2: Copy paste to Word. Record a macro, from the first line, press END, DEL, the "," key, CURSOR LEFT (it should jump to the next line, if not, use CURSOR DOWN, HOME)
Stop macro record, run macro record until the end.

Option 3: VB script (maybe I will provide code later if you really need it)
0
 
Dan CraciunIT ConsultantCommented:
You don't need a macro in Word.

Just press CTRL+H (or click on "Replace"), then type ^p in the find box and , in the replace box.
Or, if your file has Unix style endings, type ^l in the find box and , in the replace box.

HTH,
Dan
0
 
käµfm³d 👽Commented:
What programs (i.e. text editors) do you have access to?
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
Praveen VenuCommented:
Copy this to excel, in the second column add comma and drag to the end row.
Now copy back to notepad.
0
 
tonydbaAuthor Commented:
I tried with this but now working..
Advanced editors like Notepad++. Use advanced find & replace:
find: \n\r
replace: ,
0
 
Dan CraciunIT ConsultantCommented:
You have Unix style line endings.

In find you need: \n
replace with ,
0
 
KimputerCommented:
Sorry, my bad:
it's: \r\n
(But you have to set search mode to Extended, it's in the same window left bottom)
0
 
Dan CraciunIT ConsultantCommented:
To see the kind of line endings you have, go to View->Show symbol->Show end of line.
notepad    replace
0
 
tonydbaAuthor Commented:
tried with \n
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now