×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

insert carriage return after asterisk in text doc

insert carriage return after asterisk in text doc

insert carriage return after asterisk in text doc

(OP)
Hi there guys, I was wondering if someone could lend me some expertise.

I have a rather large multi line file that while it should have been a single record per line limited to 512 characters, there is an asterisk and another line begins bringing the total character count to 1024. Is there a way to insert a carriage return after the asterisk or divide the lines up at the 512'th character?

This is just a plain text doc in notepad in windows. Here is a sample of where I would like to try to insert the carriage return to push it to the next line so I only have 512 characters in a single line.

*I6097546730

The asterisk is the 512th character and the I is the 513th, is there a way to create an "enter" insert or carriage return that will push the I to the next line? I have about 30k lines to do this to.

I can pull the doc into excel, access, or word, but I can not find a way to split the lines after the asterisk.

Thanks!!

RE: insert carriage return after asterisk in text doc

Create a linked table to a copy of it in Access, then use an Update query to replace the contents of the field with

Replace (Fieldname, "*", "*" & vbCrLf)

Note: This is theory only, I've not had a chance to test this properly.

John

RE: insert carriage return after asterisk in text doc

(OP)
I will give it a shot.

Thanks for the tip!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close