|
View previous topic :: View next topic
|
| Author |
Message |
jimsnow
New User
Joined: 20 Feb 2023
Posts: 9
Location: us
|
|
|
|
Hello -
First, apologies for posting this as a reply on an old topic. I caught my mistake too late to delete it...
I have a situation where I need to combine multiple unique records into a single record.
Input (FB 80/data length = 12 bytes/trailing spaces):
100AXXXXXXXX
100BXXXXXXXX
100CXXXXXXXX
.
.
.
100ZXXXXXXXX
Desired Output (FB 240 assuming 20 input records) :
100AXXXXXXXX100BXXXXXXXX100CXXXXXXXX...100ZXXXXXXXX
The data will not have duplicates. The output dataset will not contain trailing spaces, just the 12 bytes of data per input record. Expected volume is 20 records daily, but can vary by a record or 2.
I have looked for similar SPLICE examples in the forum, but have not located a similar post (most contain keyed data). Any suggestions are greatly appreciated. |
|
| Back to top |
|
 |
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1329
Location: Bamberg, Germany
|
|
|
|
| Please look for RESIZE operator of ICETOOL. |
|
| Back to top |
|
|
jimsnow
New User
Joined: 20 Feb 2023
Posts: 9
Location: us
|
|
|
|
forest through the trees...
so fixated on SPLICE, failed to consider RESIZE
Thank you, Joerg |
|
| Back to top |
|
|
|
|
