Perl / Sed script ajudar

sabyasm · #1 (**permalink**) 06-04-2008

Todas oi,

Gostaria de necessidade de gerar scripts Oracle Inster de uma planilha excel formatado como segue:

CitaÃ§Ã£o:

SRVC_ROLE_SPECIFICATION
REC 1
SRVC_ROLE_SPEC_ID : 1
SRVC_ROLE_TYPE : HeAdmin
MIN_NUMBER_ALLOWED : 1
MAX_NUMBER_ALLOWED : 1
IDENTIFIER_NAME_SPACE : NULL
CREDENTIAL_TYPE : ENCRYPTEDTEXT
SRVC_SPECIFICATION_ID : 1
REC 2
SRVC_ROLE_SPEC_ID: 2
SRVC_ROLE_TYPE: emailLite
MIN_NUMBER_ALLOWED: 1
MAX_NUMBER_ALLOWED: 10
IDENTIFIER_NAME_SPACE:
CREDENTIAL_TYPE: ENCRYPTEDTEXT
SRVC_SPECIFICATION_ID: 1
REC 3
SRVC_ROLE_SPEC_ID: 3
SRVC_ROLE_TYPE: hostopiaAdmin
MIN_NUMBER_ALLOWED: 1
MAX_NUMBER_ALLOWED: 1
IDENTIFIER_NAME_SPACE:
CREDENTIAL_TYPE: ENCRYPTEDTEXT
SRVC_SPECIFICATION_ID: 2
REC 4
SRVC_ROLE_SPEC_ID: 4
SRVC_ROLE_TYPE: voicemailAdmin
MIN_NUMBER_ALLOWED: 1
MAX_NUMBER_ALLOWED: 1
IDENTIFIER_NAME_SPACE:?
CREDENTIAL_TYPE: ENCRYPTEDTEXT
SRVC_SPECIFICATION_ID: 2
REC 5
SRVC_ROLE_SPEC_ID: 5
SRVC_ROLE_TYPE: voicemailUser
MIN_NUMBER_ALLOWED: 1
MAX_NUMBER_ALLOWED: NULL (isto indica que nÃ£o hÃ¡ limite superior)
IDENTIFIER_NAME_SPACE:
CREDENTIAL_TYPE: ENCRYPTEDTEXT
SRVC_SPECIFICATION_ID: 2

Isso tem de ser despojado do seguinte modo:

CitaÃ§Ã£o:

REC 1: INSERT INTO SRVC_ROLE_SPECIFICATION (SRVC_ROLE_SPEC_ID, SRVC_ROLE_TYPE, MIN_NUMBER_ALLOWED, MIN_NUMBER_ALLOWED, MAX_NUMBER_ALLOWED, IDENTIFIER_NAME_SPACE, CREDENTIAL_TYPE, SRVC_SPECIFICATION_ID)
VALORES
(1, 'heAdmin', 1,1, 'NULL', 'ENCRYPTEDTEXT', 1);

REC 2: ..

REC 1, REC 2 etc sÃ£o os separadores de registros ...

Creio que uma pÃ©rola script pode ser escrito para este ... algo Ãºtil serÃ¡ de grande ajuda.

Thanks in Advance
Sabya

Mais UNIX e Linux FÃ³rum TÃ³picos VocÃª pode achar Helpfull
Fio	Thread Starter	FÃ³rum	Respostas	Ãšltima postagem
Chamando um script perl de um script perl	new2ss	ProgramaÃ§Ã£o Shell Script e	6	05-24-2009 06:03
Incluir Perl no Unix shell script	Ganapati	UNIX para Dummies Perguntas & Respostas	1	04-29-2008 01:18
aqui documento para automatizar script perl que chamam script	hogger84	ProgramaÃ§Ã£o Shell Script e	3	10-22-2007 11:15
Modificar scripts para trabalhar com txt - PermissÃµes script	joangopan	ProgramaÃ§Ã£o Shell Script e	1	09-13-2007 12:38
Perl: Executar script perl no atual processo	vino	ProgramaÃ§Ã£o Shell Script e	10	12-09-2005 10:45

Thread Tools	Pesquisar este Thread
Show Printable Version Enviar esta pÃ¡gina	Pesquisar este Thread: Pesquisa AvanÃ§ada
Display Modes	Esta taxa Thread
Mude para o Modo Linear Switch to Hybrid Mode Threaded Mode	Esta taxa Thread:


	Powered by