0

Hi ,

I have a excel sheet.in that one column called hardcoded.
we have sheet as folllows.
Name EMp_ID Hardcoded
----------------------------
ABC 1987870 1. EMP_SAL_CD : "2000","1300","Avg100"
2. DEPT_CD : "Manager","clerk","anlyst"
3. DNAME : "SALES","HR"
STU 1909890 1.EMP_SAL_CD : "6000","300","A100"
2. DEPT_CD : "Manr","cle","ant"
3. DNAME : "SALES","HR","STUD"
---
---

Now I want the O/P as follws

Name EMp_ID EMP_SAL_CD DEPT_CD DNAME
---------------------------------------------------------------------------------
ABC 1987870 "2000","1300","Avg100" "Manager","clerk","anlyst" "SALES","HR"
STU 1909890 "6000","300","A100" "Manr","cle","ant" "SALES","HR","STUD"
----
---
---
Can any one please help me out to write a shell script for this issue.

Thanks,
Vasu

4
Contributors
3
Replies
4
Views
5 Years
Discussion Span
Last Post by thekashyap
0

Hi ,

I have a excel sheet.in that one column called hardcoded.
we have sheet as folllows.
Name EMp_ID Hardcoded
----------------------------
ABC 1987870 1. EMP_SAL_CD : "2000","1300","Avg100"
2. DEPT_CD : "Manager","clerk","anlyst"
3. DNAME : "SALES","HR"
STU 1909890 1.EMP_SAL_CD : "6000","300","A100"
2. DEPT_CD : "Manr","cle","ant"
3. DNAME : "SALES","HR","STUD"
---
---

Now I want the O/P as follws

Name EMp_ID EMP_SAL_CD DEPT_CD DNAME
---------------------------------------------------------------------------------
ABC 1987870 "2000","1300","Avg100" "Manager","clerk","anlyst" "SALES","HR"
STU 1909890 "6000","300","A100" "Manr","cle","ant" "SALES","HR","STUD"
----
---
---
Can any one please help me out to write a shell script for this issue.

Thanks,
Vasu

Hi,

Easiest way to to switch on Record New Macro. Then do to the first record what you want and you then have a script. If you only have a few records to go through then just run the script one record at a time, if many then add aloop to your script.

Denis

0

I would recommend Office VB script. Easy and powerful, takes a day or two to learn but has very wide application.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.