Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

« previous next »
Pages: [1]   Go Down

Author Topic: Edit a text file  (Read 2749 times)

0 Members and 1 Guest are viewing this topic.

Spoiler

    Topic Starter


    Specialist

    Thanked: 50
  • Experience: Beginner
  • OS: Windows XP
Edit a text file
« on: November 29, 2016, 09:00:20 AM »
Hi All,
I get a txt file once a week. The file uses a delimiter of a pipe. ( | ) Something has changed for some reason. The vendor has now started to use a broken delimiter. I can't create it but it looks like a pipe that is broken in the middle. So you have 2 small vertical lines

Anyway I take the file and import it into the database. It can no longer read the line end so the file doesn't import. I have talked to the vendor and they are working on a fix. I had hoped that someone here might have a idea for a fix.

Thanks


Logged
Whenever I watch TV and I see those poor starving kids all over the world, I can't help but cry. I mean I would love to be skinny like that, but not with all those flies and death and stuff." - Mariah Carey, Pop Singer

Spoiler

    Topic Starter


    Specialist

    Thanked: 50
  • Experience: Beginner
  • OS: Windows XP
Re: Edit a text file
« Reply #1 on: November 29, 2016, 10:29:40 AM »
I found a free nagware program called edit pad lite. I did the job on a 6000 text file in less then a second. I'm a happy camper...

Thanks

Logged
Whenever I watch TV and I see those poor starving kids all over the world, I can't help but cry. I mean I would love to be skinny like that, but not with all those flies and death and stuff." - Mariah Carey, Pop Singer

patio

  • Moderator


    • Genius
  • Maud' Dib
    • Thanked: 1769
    • Yes
  • Experience: Beginner
  • OS: Windows 7
Re: Edit a text file
« Reply #2 on: November 29, 2016, 11:00:42 AM »
I was just gonna suggest EditPad....great app.
Logged
" Anyone who goes to a psychiatrist should have his head examined. "

Salmon Trout

  • Guest
Re: Edit a text file
« Reply #3 on: November 29, 2016, 02:13:33 PM »
Quote from: Spoiler on November 29, 2016, 09:00:20 AM
it looks like a pipe that is broken in the middle. So you have 2 small vertical lines
The normal pipe | is ASCII 124 (decimal), that new char sounds like ASCII 221 ¦

Wouldn't Notepad do the replace?
Logged

Spoiler

    Topic Starter


    Specialist

    Thanked: 50
  • Experience: Beginner
  • OS: Windows XP
Re: Edit a text file
« Reply #4 on: November 30, 2016, 01:35:58 PM »
Yes....yes it would but it wouldn't be as cool.... ;D
Logged
Whenever I watch TV and I see those poor starving kids all over the world, I can't help but cry. I mean I would love to be skinny like that, but not with all those flies and death and stuff." - Mariah Carey, Pop Singer

Salmon Trout

  • Guest
Re: Edit a text file
« Reply #5 on: November 30, 2016, 02:07:21 PM »
Quote from: Spoiler on November 30, 2016, 01:35:58 PM
Yes....yes it would but it wouldn't be as cool.... ;D
Yes, I know... I am a big SciTE fan for those times when you need a cool editor. (In fact it is my main editor.)
Logged

soybean



    Genius
  • The first soybean ever to learn the computer.
    • Thanked: 469
  • Computer: Specs
  • Experience: Experienced
  • OS: Windows 10
Re: Edit a text file
« Reply #6 on: December 01, 2016, 09:57:22 AM »
Quote from: Spoiler on November 29, 2016, 10:29:40 AM
I found a free nagware program called edit pad lite. I did the job on a 6000 text file in less then a second. I'm a happy camper...
So, exactly how did you use Edit Pad Lite to fix the data file so that it can be imported into your database.  Did you replace the "pipe" delimiters with a delimiter that the database recognizes?
Logged
Pages: [1]   Go Up
« previous next »