tvsramesha
New Member
- Joined
- Aug 12, 2016
- Messages
- 13
Hi All -
Thanks in advance, I'm using OCR conversion and importing into excel, the label from contains Japanese characters apart from alphanumeric(western) characters, want to only clean the Japanese characters, please help me with a macro to remove the Japanese characters(copied below)
Ramesha
[TABLE="width: 913"]
<colgroup><col><col><col span="2"><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]品番 1889816-1[/TD]
[TD][/TD]
[TD]サイズ[/TD]
[TD]胸囲[/TD]
[TD]90[/TD]
[TD]丫 4[/TD]
[TD][/TD]
[TD]品質表示[/TD]
[TD][/TD]
[TD]表地 毛 5 2%[/TD]
[TD][/TD]
[TD]ポリエステル4 8%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]品番 1889813-1 1[/TD]
[TD]サイズ[/TD]
[TD]胸囲胴囲[/TD]
[TD]94 82[/TD]
[TD]A6 |[/TD]
[TD]品質表不[/TD]
[TD]表地 毛 ん八丨丨丁フニ[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance, I'm using OCR conversion and importing into excel, the label from contains Japanese characters apart from alphanumeric(western) characters, want to only clean the Japanese characters, please help me with a macro to remove the Japanese characters(copied below)
Ramesha
[TABLE="width: 913"]
<colgroup><col><col><col span="2"><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]品番 1889816-1[/TD]
[TD][/TD]
[TD]サイズ[/TD]
[TD]胸囲[/TD]
[TD]90[/TD]
[TD]丫 4[/TD]
[TD][/TD]
[TD]品質表示[/TD]
[TD][/TD]
[TD]表地 毛 5 2%[/TD]
[TD][/TD]
[TD]ポリエステル4 8%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]品番 1889813-1 1[/TD]
[TD]サイズ[/TD]
[TD]胸囲胴囲[/TD]
[TD]94 82[/TD]
[TD]A6 |[/TD]
[TD]品質表不[/TD]
[TD]表地 毛 ん八丨丨丁フニ[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]