Search found 32 matches

by RMSoares
19 Sep 2014 04:13
Forum: DOS Batch Forum
Topic: Converting one record to many
Replies: 33
Views: 18820

Re: Converting one record to many

Good Morning, the formatting of the file has been changed, is currently fomatting is that indicated <Header 12 characters> <Block 1 - with 99 characters> <Block 2 - with 99 characters> <Block 3 - 99 characters with> ... <Block n - with 99 characters> It is not possible to indicate the number of blo...
by RMSoares
19 Sep 2014 01:23
Forum: DOS Batch Forum
Topic: Converting one record to many
Replies: 33
Views: 18820

Re: Converting one record to many

Good Morning, the formatting of the file has been changed, is currently fomatting is that indicated <Header 12 characters> <Block 1 - with 99 characters> <Block 2 - with 99 characters> <Block 3 - 99 characters with> ... <Block n - with 99 characters> It is not possible to indicate the number of bloc...
by RMSoares
18 Sep 2014 11:40
Forum: DOS Batch Forum
Topic: Converting one record to many
Replies: 33
Views: 18820

Re: Converting one record to many

Hi, there is only two records, the first with 806 charcaters and the second record with 1004 characters TXAR0023012251200000000000101800004209LT 00000002000EUR0000000000400000000021023000CT0000420900000000000000000001200000000000101800004209LT 00000002000EUR0000000000400000000021023000CT000042090000...
by RMSoares
18 Sep 2014 11:22
Forum: DOS Batch Forum
Topic: Converting one record to many
Replies: 33
Views: 18820

Re: Converting one record to many

Hi, the example taht i had inclued in my post is an export from the input file of the process TXAR0023012251200000000000101800004209LT 00000002000EUR0000000000400000000021023000CT0000420900000000000000000001200000000000101800004209LT 00000002000EUR0000000000400000000021023000CT0000420900000000000000...
by RMSoares
18 Sep 2014 07:12
Forum: DOS Batch Forum
Topic: Converting one record to many
Replies: 33
Views: 18820

Re: Converting one record to many

There is any why to resolved this limitation of 1024 characters ?
by RMSoares
18 Sep 2014 06:14
Forum: DOS Batch Forum
Topic: Converting one record to many
Replies: 33
Views: 18820

Re: Converting one record to many

I am using a batch to convert a record in several records. The logic will always be to find a certain type of record ("TXAR") create several records, as many as the number of blocks of 99 existing carcateres the register. Since the final output for each record must contain the first 13 cha...
by RMSoares
18 Mar 2013 10:33
Forum: DOS Batch Forum
Topic: Check file size
Replies: 4
Views: 3563

Check file size

Good afternoon, I'm getting a set of files from ftp, with fixed size of 135 characters, from a mainframe, we have detected a number of errors in processing these files because same records appear to have different size than expected. I would like to have a batch that validate the file size and conta...
by RMSoares
17 Oct 2012 11:02
Forum: DOS Batch Forum
Topic: Converting one record to many
Replies: 33
Views: 18820

Re: Converting one record to many

Thanks abc0502 for your help, it work's!
by RMSoares
17 Oct 2012 09:15
Forum: DOS Batch Forum
Topic: Converting one record to many
Replies: 33
Views: 18820

Re: Converting one record to many

You want FREE help, but you won't answer a question about the task. Or is your English so poor that you can't understand what I've asked three times? foxidrive, I appreciate any help you can give me, for I am not **consored** in VBS. I am sorry that my English is bad, but try to answer all question...
by RMSoares
17 Oct 2012 08:08
Forum: DOS Batch Forum
Topic: Converting one record to many
Replies: 33
Views: 18820

Re: Converting one record to many

foxidrive wrote:
abc0502 wrote:I want to know how many movements there can be because batch has line length limitations. If it's a large number of movements then VBS needs to be used.


The number of movement is variable
by RMSoares
17 Oct 2012 08:07
Forum: DOS Batch Forum
Topic: Converting one record to many
Replies: 33
Views: 18820

Re: Converting one record to many

So any line that start with " R " and end with " Y " will be converted .... No, not true, the last caracter could have any different letter (it defined the type of movement) The Layout of record R is R<14 charcater's><1 or more blocks with 15 character eache><1 character that wi...
by RMSoares
17 Oct 2012 08:01
Forum: DOS Batch Forum
Topic: Cutting strings where is the character "!"
Replies: 9
Views: 5340

Re: Cutting strings where is the character "!"

Edit : I don't know if that what you mean but you want this line: 312CCAAPT01 7106 GO!SERVICE - ONDERNEMINGEN KOMT - STAR XX!TECKDAILY - MASTER COMPANY, I123456789 YY!SERVICE - EXCHANGE 001ACTIVE FFBSTYUI 000000000000000000000000 without the blue letters and numbers Now i see that are missing same ...
by RMSoares
17 Oct 2012 07:50
Forum: DOS Batch Forum
Topic: Converting one record to many
Replies: 33
Views: 18820

Re: Converting one record to many

How many 15 character blocks can there be in one R type record? the number of blocks is variable, there may be records with 1 occurrences and in other cases with n occurrences. There was more than one question in my post. I can't give you a solution without the answer... and SED is a third party fr...
by RMSoares
17 Oct 2012 06:38
Forum: DOS Batch Forum
Topic: Cutting strings where is the character "!"
Replies: 9
Views: 5340

Cutting strings where is the character "!"

Hi, I'm using a batch to cut the first 11 characters of each record in a text file. @echo off setlocal EnableDelayedExpansion for /F "delims=" %%a in (b.out) do ( set "Line=%%a" >>d.out echo(!Line:~11! ) My Input is a file b.out with fowlling record 312CCAAPT01 7106 GO!SERVICE - ...
by RMSoares
17 Oct 2012 06:37
Forum: DOS Batch Forum
Topic: Converting one record to many
Replies: 33
Views: 18820

Re: Converting one record to many

Can you send me an example of the used of SED ?