insert a carriage return.. (excel 2000)

Topic

New Reply

Messaggio cancellato da sal21

Reply | Quote

Replies

This seems very consistent. There is a line of 132 hyphens (-), then a space, then the next line. You could look for a pattern such as ———- plus space and replace that with ———- plus a CRLF pair plus space.

It would be cumbersome to load Word just to do that, so as an alternative you could use Replace on a really huge string or you could do a file operation (I don’t know the code for that, but I’m sure there is a way, perhaps using VBScripts Regular Expressions object).

Maybe if you get the original report to only have 131 – characters in a row, it will fix itself?

Reply | Quote

This seems very consistent. There is a line of 132 hyphens (-), then a space, then the next line. You could look for a pattern such as ———- plus space and replace that with ———- plus a CRLF pair plus space.

It would be cumbersome to load Word just to do that, so as an alternative you could use Replace on a really huge string or you could do a file operation (I don’t know the code for that, but I’m sure there is a way, perhaps using VBScripts Regular Expressions object).

Maybe if you get the original report to only have 131 – characters in a row, it will fix itself?

Reply | Quote

Hi Sal,

The last thing I would wish to do is sent you away from this forum, but I suspect you might be better off asking your questions in Italian, right?

Try this site, it is the Italian Microsoft Newsgroup on Excel

Reply | Quote

Now look what you’ve done! Hope this wasn’t because Sal took offence.
Cheers

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

From last night’s digest:[indent]

---

Subject: insert a carriage return.. (excel 2000) [#338805]
Poster: sal21
Posted on: 02-Feb-04 21:50

.. acarriage return.

This file is generated from an CICS/HOST Application.
Not all line of this are longer 132.
I dont know the reason?????

My problem:

Count 132 charatter for every line and put a carriage return if many line as to big out of 132 character
Is pssible whit a macro to make this and end sub and to save as with overwrith the original file or save in another position of Hdisk?
If you want make also an import in a sheet of excel and make a macro…

Attachment:

---

[/indent]If you must know.

Reply | Quote

Thanks Jefferson,

I had seen the original post, so I remembered its gist. Glad you had a copy of the benefit of others though.

Cheers

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

I am sooo glad to see some of us keep record of what’s in here .
I wouldn’t have known what to do with my day today without being able to read Sal’s original post, thanks.

Reply | Quote

I am sooo glad to see some of us keep record of what’s in here .
I wouldn’t have known what to do with my day today without being able to read Sal’s original post, thanks.

Reply | Quote

Thanks Jefferson,

I had seen the original post, so I remembered its gist. Glad you had a copy of the benefit of others though.

Cheers

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

From last night’s digest:[indent]

---

Subject: insert a carriage return.. (excel 2000) [#338805]
Poster: sal21
Posted on: 02-Feb-04 21:50

.. acarriage return.

This file is generated from an CICS/HOST Application.
Not all line of this are longer 132.
I dont know the reason?????

My problem:

Count 132 charatter for every line and put a carriage return if many line as to big out of 132 character
Is pssible whit a macro to make this and end sub and to save as with overwrith the original file or save in another position of Hdisk?
If you want make also an import in a sheet of excel and make a macro…

Attachment:

---

[/indent]If you must know.

Reply | Quote

Now look what you’ve done! Hope this wasn’t because Sal took offence.
Cheers

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

Hi Sal,

The last thing I would wish to do is sent you away from this forum, but I suspect you might be better off asking your questions in Italian, right?

Try this site, it is the Italian Microsoft Newsgroup on Excel

Reply | Quote