Notepad space removal issue

Question

I have attached a small piece of the list below.

You can download the file by going to: http://speedy.sh/JunQS/testsssssss.txt

As you can see from the text file, it is in this format:

username : password

I need it to be in the following format:

username:password

If you take a look at the file I've given above you will understand my scenario.

I have spent the last hour and half browsing through Stackoverflow, and other sites with no luck. Nothing seems to be working so if one of you guys find a fix Id be quite surprised.

If it's the file you linked, it has 6 lines. Otherwise fair enough — ArtOfCode, Nov 01 '14 at 20:15

score 0 · Answer 1 · answered Nov 01 '14 at 19:46

0

Windows Notepad?

CTRL+h

Search for: SPACE replace with: NOTHING OR NULL

Is that what you are looking for?

Thanks!

answered Nov 01 '14 at 19:46

Leptonator

3,379
2
38
51

What kind of encoding are you using? UTF or ANSI? What is generating this? I think you need to give us some more detail as to what you are doing? Otherwise, you are going to have to use something a bit more powerful than Windows Notepad - Like TextPad, Ultraedit, EditPad.. – Leptonator Nov 01 '14 at 19:48
I have attached a small piece of the list below. You can download the file by going to: http://speedy.sh/JunQS/testsssssss.txt As you can see from the text file, it is in this format: username : password I need it to be in the following format: username:password If you take a look at the file I've given above you will understand my scenario. I have spent the last hour and half browsing through Stackoverflow, and other sites with no luck. Nothing seems to be working so if one of you guys find a fix Id be quite surprised. – Andrews Nov 01 '14 at 20:07

Tomasz Godziński · Answer 2 · 2014-11-01T20:40:30.877

0

There are tabulators between colons.
If you have notepad++ just remove them by regexp:
Search/Find/Replace
Search Mode: Regular expression
Find what: \t
Replace with:

edited Nov 01 '14 at 20:40

answered Nov 01 '14 at 19:48

Tomasz Godziński

483
4
14

score 0 · Answer 3 · answered Nov 01 '14 at 20:43

0

Ctrl + F in NPP will bring up Find/Replace. Switch to the Replace tab and use these values:

Find what: \s
Replace with: (blank)

Then in Search Mode, use Regular Expression and hit Replace All. Job done.

answered Nov 01 '14 at 20:43

ArtOfCode

5,702
5
37
56

Notepad space removal issue

3 Answers3