USUÁRIO:      SENHA:        SALVAR LOGIN ?    Adicione o VBWEB na sua lista de favoritos   Fale conosco 

 

  Fórum

  Visual Basic
Voltar
Autor Assunto:  SUBSTITUIR LETRAS NO ARQUIVO TEXTO
LUIZ PEDRO
SAO PAULO
SP - BRASIL
ENUNCIADA !
Postada em 05/06/2008 18:22 hs            
Ai vai o exemplo de uma linha:


000000000000091732528240945813     MARIA RODRIGUES DE MOURA                                                                                                                                                                                                                                                 1                                                                                                                                                                                                                                                                         11 73224097C                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    SECRETARIA                                  11 22929679ESECRETARIA                                  11 22911941ESECRETARIA                                  11 22911295ESECRETARIA                                  11 26938285ESECRETARIA                                  11 22928077E                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     000000009173252

Lembrando que tudo isso fica em uma linha só !
   
Treze
Pontos: 2843 Pontos: 2843
SÃO VICENTE
SP - BRASIL
ENUNCIADA !
Postada em 05/06/2008 18:38 hs            
então colega faça o que eu disse anteriormente
 
suponha que eu queira fazer a seguinte alteração na linha
 
000000000000091732528240945813     MARIA RODRIGUES DE MOURA                                                                                                                                                                                                                                                 1                                                                                                                                                                                                                                                                         11 73224097C                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    SECRETARIA                                  11 22929679ESECRETARIA                                  11 22911941ESECRETARIA                                  11 22911295ESECRETARIA        
 
trocar o 11 po espaco em branco
então eu pego os caracteres até o 11 e coloco em um len para saber onde alterar
 
cod="0000000091732528240945813     MARIA RODRIGUES DE MOURA                                                                                                                                                                                                                                                 1                                                                                                                                                                                                                                                                         11 73224097C                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    SECRETARIA                                  11 22929679ESECRETARIA                                  11"
 
Num=len(cod) 'o resultado de len será 255
 
então faço isto
 
linha=Mid(cod,num-2,2)
replace(cod,"11","  ")
 
não sei se você entendeu
mas é isto
 
 
   
LUIZ PEDRO
SAO PAULO
SP - BRASIL
ENUNCIADA !
Postada em 05/06/2008 19:42 hs            
E ai amigo

Entendi um pouco, fiz estas alteracoes mas nao funcionou.

Do Until EOF(arqori)
Line Input #arqori, linha
cod = linha
num = Len(cod)

linha = Mid(cod, num - 1)
cod= Replace(cod, "1", "")
Print #arqdest, linha
  
Loop
  
  MsgBox "Operacao concluida !"
  Close #arqori
   Close #arqdest
   
Treze
Pontos: 2843 Pontos: 2843
SÃO VICENTE
SP - BRASIL
ENUNCIADA !
Postada em 05/06/2008 19:59 hs            
não funcionou porqu você deve abrir manualmente um linha do arquivo selecionar somente até onde está o que deseja alterar
ai sim colocar dentro do len, mas isto só para saber a quantidade de caracteres até onde deseja alterar
 
vamos á um exemplo
 
insira um botão no form e cole este código
 
Private Sub Command1_Click()
dim Linha as Integer
Linha=Len("coloque aqui somente o trecho da string que vai do inicio até onde deseja alterar"
Msgbox Linha
End sub
 
feito isso clique no botão
 
a msgbox irá exibir o numeroque você usará
 
então ai sim coloque o mesmo na mid
 
veja como
 
supondo que o numero seja 400
 
Line Input #arqori, linha
linha = Mid(cod, 400- 1,1)
cod= Replace(cod, "1", " ")
Print #arqdest, linha
Loop
e pronto entendeu agora
 
o comannd1 você pode descartar o mesmo foi feito apenas para descobrir onde está o caractere
   
LUIZ PEDRO
SAO PAULO
SP - BRASIL
ENUNCIADA !
Postada em 06/06/2008 18:53 hs            
Ola amigo

Nao funcionou ! ele apagou tudo e so deixou o numero 1 e quero ao contrario, quero que apague somente o numero 1 na coluna 301.
   
Treze
Pontos: 2843 Pontos: 2843
SÃO VICENTE
SP - BRASIL
ENUNCIADA !
Postada em 06/06/2008 18:55 hs            
Envia o código pra mim com o arquivo texto, ou pelo menos uma das linhas informe qual o numero deseja apagar, e mande também o banco de dados.
 
que dou uma olhada e retorno pra você
 
   
Página(s): 2/4     « ANTERIOR    PRÓXIMA »


Seu Nome:

Seu eMail:

ALTERAR PARA MODO HTML
Mensagem:

[:)] = 
[:P] = 
[:(] = 
[;)] = 

HTML DESLIGADO

     
 VOLTAR

  



CyberWEB Network Ltda.    © Copyright 2000-2025   -   Todos os direitos reservados.
Powered by HostingZone - A melhor hospedagem para seu site
Topo da página