Page 1 of 1

Reformat fields from two files.

PostPosted: Mon Mar 23, 2015 6:47 pm
by TECH99
I have two data sets that are FB,80 bytes. I'm trying to copy F1 data from 1-18 and the names from F2. The = sign in front of the names starts in cols 35, but I;m not sure how to reformat the OP dataset to have the names in col 22. Any thoughts on how to accomplish this task?

F1 data starts in col 1-18

PLREP130 HQ11111 A
PLREP130 HQ22222 I
PLREP130 HQ33333 I
PLREP130 HG44444 A
PLREP130 HQ55555 I
PLREP130 HQ66666 A
*******************************************************
F2 data starts in col 1-80

ACCESSORID = HQ11111 NAME = PETER HOUSE
ACCESSORID = HQ22222 NAME = STEVE JOHNSON
ACCESSORID = HQ33333 NAME = MARK TWAIN
ACCESSORID = HQ44444 NAME = TIM ALLEN
ACCESSORID = HQ55555 NAME = MARK SMITH
ACCESSORID = HQ66666 NAME = TOM APPLE
************************************************************************************
OPDS

PLREP130 HQ11111 A PETER HOUSE
PLREP130 HQ22222 I STEVE JOHNSON
PLREP130 HQ33333 I MARK TWAIN
PLREP130 HG44444 A TIM ALLEN
PLREP130 HQ55555 I MARK SMITH
PLREP130 HQ66666 A TOM APPLE