We help IT Professionals succeed at work.
Get Started

formatting RACF Listuser output

733 Views
Last Modified: 2013-11-09
i requested a user list and within the output the user record is split across two or three rows and no common delimiter that i could use to pull the data into a spreadsheet/database to analyze.  
here are three examples of user records as they appear in the output; based on the user having privileges or not, I'm getting 3 different record formats for users within the same output

USER=ASCHINT  NAME=S-ASCHINT STC         OWNER=DC        CREATED=01.190
 INSTALLATION-DATA=IBM 903361
USER=ATTDAEMN  NAME=S-BROWN.MATTHEW       OWNER=$MVSST    CREATED=10.064
 INSTALLATION-DATA=IBM 903361 897
 UID= 0000000000
USER=BMUC061  NAME=B-RICHARDT.NICK       OWNER=GP        CREATED=00.003
 ATTRIBUTES=OPERATIONS
 INSTALLATION-DATA=IBM 8A8348 897

need a script to make the above look like (structured column and row data)


user		name			owner		created		attributes	installation-data			UID	
ASCHINT		S-ASCHINT STC		DC		01.190				IBM 903361
ATTDAEMN	S-BROWN.MATTHEW 	$MVSST		10.064				IBM 903361 897				0000000000
BMUC061		B-RICHARDT.NICK		GP		00.003		OPERATIONS  	IBM 8A8348 897

Open in new window

user-data-sample.txt
Comment
Watch Question
Get vaccinated; Social distance; Wear a mask
CERTIFIED EXPERT
Top Expert 2014
Commented:
This problem has been solved!
Unlock 2 Answers and 4 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE