Forum Discussion

Brass Contributor

Dec 29, 2023

Solved

I try to know which character I am facing

Hello, I am reading pdf information and I already got the text I was looking for, but this one has two characters at the beginning that I can't delete. Apparently, they are not simple spaces, becau...

excel

Formulas and Functions

Macros and VBA

office 365

training

djclements
Dec 29, 2023
LuisElCaminante You've already done everything correct to identify the two leading characters (13 = Carriage Return; 10 = Line Feed), and the Replace method is working. The only mistake you've made is to use documento as the Expression argument when defining dc both times... the second time, dc should have been used as the Expression argument.

You really only need one variable, documento, which can be redefined and reduced after each use of Replace. For example:

documento = Trim(vector(0)) documento = Replace(documento, Chr(13), "") documento = Replace(documento, Chr(10), "")

Or you can combine all three steps into one line:

documento = Replace(Replace(Trim(vector(0)), Chr(13), ""), Chr(10), "")

I hope that helps. Cheers!

djclements

Silver Contributor

Dec 29, 2023

LuisElCaminante You've already done everything correct to identify the two leading characters (13 = Carriage Return; 10 = Line Feed), and the Replace method is working. The only mistake you've made is to use documento as the Expression argument when defining dc both times... the second time, dc should have been used as the Expression argument.

You really only need one variable, documento, which can be redefined and reduced after each use of Replace. For example:

documento = Trim(vector(0))
documento = Replace(documento, Chr(13), "")
documento = Replace(documento, Chr(10), "")

Or you can combine all three steps into one line:

documento = Replace(Replace(Trim(vector(0)), Chr(13), ""), Chr(10), "")

I hope that helps. Cheers!

LuisElCaminante

Brass Contributor

Dec 29, 2023

Thank you very much, sorry for the code, it looks messy like that because I was trying to figure out what was going on.

I inserted a lot of intermediate variables, to try to understand, which I also ended up confusing.

Thank you very much, you gave me light to give me a solution to the problem.