Hi,
I've attached a text file containing the original and required format and
avoid the format
being lost by just pasting it in the email body.
The original format is separated by a space, but need to replace the space
with a comma,
so it will become a comma delimited csv file which I will then import to MS
Excel.
I'm not sure how to parse the "Connection" and "Sync'ed-as-of-time" columns
since the dates
there in is in this format "Fri Jun 24 06:37" which also separated by space,
but the spaces in
those columns shouldn't be replaced by a comma. The date format in those
columns should
remain the same.
Also, is it possible to convert this directly into a MS Excel document using
Perl?
Many thanks!
Regards,
Wernher
Original Format
===============
CTX Destination
Enabled Connection Sync'ed-as-of-time
--- ---------------------------------------------------------------------
------- ---------------- ------------------
1 pool://ZABRYDD01.localdomain/RDP_NEW_REP
yes Sat Jun 18 08:56 Fri Jun 24 06:37
2 dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test101
yes Sat Jun 18 08:57 Fri Jun 24 08:01
4 dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test22
yes Sat Jun 18 08:57 Fri Jun 24 09:00
5 pool://ZARDPDD01.localdomain/BRYREP
yes Sat Jun 18 08:57 Fri Jun 24 07:01
8 dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test31
yes Sat Jun 18 08:57 Fri Jun 24 09:00
10 dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test421
yes Sat Jun 18 08:57 Fri Jun 24 09:00
12 dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test5
yes Sat Jun 18 08:57 Fri Jun 24 09:00
13 dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test60
yes Sat Jun 18 08:57 Fri Jun 24 09:00
15 dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test767
yes Sat Jun 18 08:56 Fri Jun 24 08:01
18 dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test83
yes Sat Jun 18 08:56 Fri Jun 24 09:00
19 dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test91
yes Sat Jun 18 08:56 Fri Jun 24 09:00
20 dir://ZABRYDD01.localdomain/backup/ZARDPDD01REP/linux/backup/test10
yes Sat Jun 18 08:56 Fri Jun 24 09:00
23 dir://ZABRYDD01.localdomain/backup/ZARDPDD01REP/linux/backup/test14
yes Sat Jun 18 08:56 Fri Jun 24 09:00
25 dir://ZABRYDD01.localdomain/backup/ZARDPDD01REP/linux/backup/test12
yes Sat Jun 18 08:56 Fri Jun 24 09:00
26 dir://ZABRYDD01.localdomain/backup/ZARDPDD01REP/linux/backup/test14
yes Sat Jun 18 08:56 Fri Jun 24 09:00
27 dir://ZABRYDD01.localdomain/backup/ZARDPDD01REP/linux/backup/test12
yes Sat Jun 18 08:57 Fri Jun 24 09:00
28 dir://ZABRYDD01.localdomain/backup/ZARDPDD01REP/linux/backup/test11
yes Sat Jun 18 08:57 Fri Jun 24 09:00
31 dir://ZABRYDD01.localdomain/backup/ZARDPDD01REP/linux/backup/test167
yes Sat Jun 18 08:57 Fri Jun 24 09:00
--- ---------------------------------------------------------------------
------- ---------------- ------------------
Required Format (comma delimited)
=================================
CTX,Destination,Enabled,Connection,Sync'ed-as-of-time,
---,---------------------------------------------------------------------,-------,----------------,------------------
1,pool://ZABRYDD01.localdomain/RDP_NEW_REP,yes,Sat Jun 18 08:56,Fri Jun 24 06:37
2,dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test101,yes,Sat
Jun 18 08:57,Fri Jun 24 08:01
4,dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test22,yes,Sat
Jun 18 08:57,Fri Jun 24 09:00
5,pool://ZARDPDD01.localdomain/BRYREP,yes,Sat Jun 18 08:57,Fri Jun 24 07:01
8,dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test31,yes,Sat
Jun 18 08:57,Fri Jun 24 09:00
10,dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test421,yes,Sat
Jun 18 08:57,Fri Jun 24 09:00
12,dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test5,yes,Sat
Jun 18 08:57,Fri Jun 24 09:00
13,dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test60,yes,Sat
Jun 18 08:57,Fri Jun 24 09:00
15,dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test767,yes,Sat
Jun 18 08:56,Fri Jun 24 08:01
18,dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test83,yes,Sat
Jun 18 08:56,Fri Jun 24 09:00
19,dir://ZARDPDD01.localdomain/backup/ZABRYDD01REP/linux/backup/test91,yes,Sat
Jun 18 08:56,Fri Jun 24 09:00
20,dir://ZABRYDD01.localdomain/backup/ZARDPDD01REP/linux/backup/test10,yes,Sat
Jun 18 08:56,Fri Jun 24 09:00
23,dir://ZABRYDD01.localdomain/backup/ZARDPDD01REP/linux/backup/test14,yes,Sat
Jun 18 08:56,Fri Jun 24 09:00
25,dir://ZABRYDD01.localdomain/backup/ZARDPDD01REP/linux/backup/test12,yes,Sat
Jun 18 08:56,Fri Jun 24 09:00
26,dir://ZABRYDD01.localdomain/backup/ZARDPDD01REP/linux/backup/test14,yes,Sat
Jun 18 08:56,Fri Jun 24 09:00
27,dir://ZABRYDD01.localdomain/backup/ZARDPDD01REP/linux/backup/test12,yes,Sat
Jun 18 08:57,Fri Jun 24 09:00
28,dir://ZABRYDD01.localdomain/backup/ZARDPDD01REP/linux/backup/test11,yes,Sat
Jun 18 08:57,Fri Jun 24 09:00
31,dir://ZABRYDD01.localdomain/backup/ZARDPDD01REP/linux/backup/test167,yes,Sat
Jun 18 08:57,Fri Jun 24 09:00
---,---------------------------------------------------------------------,-------,----------------,------------------
--
To unsubscribe, e-mail: beginners-unsubscr...@perl.org
For additional commands, e-mail: beginners-h...@perl.org
http://learn.perl.org/
