Conversion of below Tabs Tex file into CSV format file : shell script needed
Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given
Name Domain Contact Phone Email Location
----------------------- ------------------------------------------------ ------- ----- --------------------------------- -------------------
clients / 5fdf97049abdd582976d954bba8ff256c4beedd8
GEN-I / Service Provider
MC_RETIRED / acb53a6470ba5fdd6efc93a0d7228e9e014a199e
REPLICATE / 5cf5275db7ceb0a7c8e29c7d66fd548f61ced14d
CUSTOMER_01 /GEN-I <<Cust01 PARTY NUMBER>>
CUSTOMER_02 /GEN-I <<Cust02 PARTY NUMBER>>
RCB_INSTANCE_01 /GEN-I/CUSTOMER_01 "Product Instance 01 Description" <<Cust01_Inst01 PRODUCT ID>>
RCB_INSTANCE_02 /GEN-I/CUSTOMER_01 "Product Instance 02 Description" <<Cust01_Inst02 PRODUCT ID>>
RCB_INSTANCE_01 /GEN-I/CUSTOMER_02 " Product Instance 01 Description" <<Cust02_Inst01 PRODUCT ID>>
wn1naeavu101.sdp.net.nz /REPLICATE 1eb4ad6f161e2be6644c13270adaa8dc7e7aa6a8
clients /REPLICATE/wn1naeavu101.sdp.net.nz d93a694ed05147f8f9895ffa57fb91a0b15ed25d
GEN-I /REPLICATE/wn1naeavu101.sdp.net.nz a4af9e4cc65ba65550b3365759280cf1197cb7da
MC_RETIRED /REPLICATE/wn1naeavu101.sdp.net.nz 892e8133bb46f16caeb4667811457e5a9126838c
REPLICATE /REPLICATE/wn1naeavu101.sdp.net.nz b983f7c9a69545b4f0a63a30f28447279a4524c2
WLGtest /REPLICATE/wn1naeavu101.sdp.net.nz/GEN-I 4d6c41eb132caae70e8a9f990201e5c83c1104b5
RCB_INSTANCE_01 /REPLICATE/wn1naeavu101.sdp.net.nz/GEN-I/CUSTOMER_02 0aec9c024ae8c9b60a81a371980e58be0eb2f27e
RCB_INSTANCE_02 /REPLICATE/wn1naeavu101.sdp.net.nz/GEN-I/CUSTOMER_03 95e059107f165bb603aabae42b59c8f51e64e855
CSV format file :
Name,Domain,Contact,Phone,Email,Location
-----------------------,------------------------------------------------,-------,-----,---------------------------------,----------------------------------------
clients,/,,,,5fdf97049abdd582976d954bba8ff256c4beedd8
GEN-I,/,,,,Service Provider
MC_RETIRED,/,,,,acb53a6470ba5fdd6efc93a0d7228e9e014a199e
REPLICATE,/,,,,5cf5275db7ceb0a7c8e29c7d66fd548f61ced14d
CUSTOMER_01,/GEN-I,,,,<<Cust01 PARTY NUMBER>>
CUSTOMER_02,/GEN-I,,,,<<Cust02 PARTY NUMBER>>
RCB_INSTANCE_01,/GEN-I/CUSTOMER_01,,,"Product Instance 01 Description",<<Cust01_Inst01 PRODUCT ID>>
RCB_INSTANCE_02,/GEN-I/CUSTOMER_01,,,"Product Instance 02 Description",<<Cust01_Inst02 PRODUCT ID>>
RCB_INSTANCE_01,/GEN-I/CUSTOMER_02,,,"Product Instance 01 Description",<<Cust02_Inst01 PRODUCT ID>>
wn1naeavu101.sdp.net.nz,/REPLICATE,,,,1eb4ad6f161e2be6644c13270adaa8dc7e7aa6a8
clients,/REPLICATE/wn1naeavu101.sdp.net.nz,,,,d93a694ed05147f8f9895ffa57fb91a0b15ed25d
GEN-I,/REPLICATE/wn1naeavu101.sdp.net.nz,,,,a4af9e4cc65ba65550b3365759280cf1197cb7da
MC_RETIRED,/REPLICATE/wn1naeavu101.sdp.net.nz,,,,892e8133bb46f16caeb4667811457e5a9126838c
REPLICATE,/REPLICATE/wn1naeavu101.sdp.net.nz,,,,b983f7c9a69545b4f0a63a30f28447279a4524c2
WLGtest,/REPLICATE/wn1naeavu101.sdp.net.nz/GEN-I,,,,4d6c41eb132caae70e8a9f990201e5c83c1104b5
RCB_INSTANCE_01,/REPLICATE/wn1naeavu101.sdp.net.nz/GEN-I/CUSTOMER_02,,,,0aec9c024ae8c9b60a81a371980e58be0eb2f27e
RCB_INSTANCE_02,/REPLICATE/wn1naeavu101.sdp.net.nz/GEN-I/CUSTOMER_03,,,,95e059107f165bb603aabae42b59c8f51e64e855
Last edited by sreenath1037; 04-29-2011 at 03:39 AM..