How to separate text code

Navigation
0
Hi good afternoon person, how are you?

I have a question that I would like to know if you can assist me, please:

I have a .txt file, which contains more than 1000 lines, I need to separate the code from the text .... I explain myself better with the example: 

CO123456= texto1      (Primeira Linha )
CO123457= texto2      (Segunda Linha )    
CO123458= texto3      (Terceira Linha )

I need to delete ( CO123456= , CO123457= and CO123458= ) or stay texto1 , texto2 and texto3 .... thus: 

texto1      (Primeira Linha )
texto2      (Segunda Linha )    
texto3      (Terceira Linha )

I tried to do this with "Replace" mode in Excel, but I could not ... because I had lines that had many equal signs (=), thus eliminating the whole sentence.

Any suggestions?

    
asked by anonymous 21.09.2016 / 19:45

1 answer

2

If you have a pattern for the code, where you will always have to remove the 9 character code, an equality symbol, and a space, you can use the following code 

=RIGHT(A1; LEN(A1)-10)

Explaining:

A1 - Cell in which the rule will be applied.

LEN(A1)-10 - Finds the cell size (in case A1), and subtracts an amount x of characters (in case 10).

Now just apply this formula to all your cells. I believe that will be the least of the problems.

    
21.09.2016 / 20:15
Where to treat data in an MVC project Problems with Json Encode of PHP?