Remove chinese chars

[Smrie]

Hi,

I have excel files which containing chinese characters. When i run code on these files i get an error while saving. Showing me that file "Some filename ?????" can not be found. It seems it converts chinese characters to question marks.
I tried a regex as seen below to remove the chinese pattern or question marks with string - 9 characters because that would remove them always. ( i also tried [\u4E00-\u9FFF]) But i can not use the name as function because the name in the variable Fname with ???? is different from the actual file in my folder which has chinese characters, which i can not get in a variable. How do i get around this?. See my code below.

Please Login or Register  to view this content.

[PCI]

I have excel files which containing chinese characters

You mean

which containing chinese characters in the file name

is it ?
Can you attach a short sample of these files

[PCI]

Today in the code your are showing, you are deleting the 9 last characters on the right ( included extension ) .
Is it what you want ?

[Smrie]

Hi,

Yeah this is what i need. The code from yesterday works i just to need to be able to rename the excel files.
Names are like WB0068638LNV*CICU8610449*IV*PL笔记本电脑 & CICU8607569*PL.LV*显示器. I rather not share the excel files because it contains customer data. It is

I think it is because these are unicode characters. These files where created on a system with different language settings And can not be read to a string in vba because it is ANSII. Ill try to use Filesystemobject. Hopefully someone can help me out with a solution if that does not work.

[davsth]

Its difficult without files

why not list all the files in the folder to a spreadsheet. There are numerous bits of vba code that do this google it

Please Login or Register  to view this content.

do these filenames contain ? or Chinese characters?
can you open these files with the name provided by the spreadsheet?

[PCI]

I rather not share the excel files because it contains customer data

Just send a file with nothing inside but with the right name
Show what you need finally:
from WB0068638LNV*CICU8610449*IV*PL笔记本电脑 & CICU8607569*PL.LV*显示器
what is the result you want ??

[Smrie]

Hi, thank you all for taking the time to look at my problem.

Please Login or Register  to view this content.

This does not work. I get an error 455, which when i google it says filesearch is outdated. I can try to use filesystemobject. I'll try that out today.

from WB0068638LNV*CICU8610449*IV*PL笔记本电脑 & CICU8607569*PL.LV*显示器
what is the result you want ??

CICU8610449*IV*PL
CICU8607569*PL.LV

But anything with non chinese characters is fine. I added 2 files as an example.

[Smrie]

I tried a filesystemobject code:

Please Login or Register  to view this content.

This show the following result:

• CICU8052440;*IV*PL?????.xls
• CICU8052706*IV*PL?????.xls
• CICU8054247*PL.LV*???.xls
• CICU8054817IV*PL?????.xls
• CICU8054843*IV*PL?????.xls
• CICU8055270*PL.LV*???.xls
• CICU8606705*PL.LV*???.xls

[Smrie]

Thank you all for trying to help. I solved it. For those interested, ill post the code. I used the Like statement when renaming the file.

Please Login or Register  to view this content.