Extract data from txt

Help
,
#1

Hello All,

I am trying to extract the data from txt to excel.

Here is the text I am extract now

CHARGE SGD
HANDLING CHARGE EXPORT 75.00 EUR 124.83 0

I use below to write to cell.
((textData.Split(vbnewline.ToCharArray)(counter+2).ToString).Split(" "c)).first

However, I can only get the first data.
%E5%9B%BE%E7%89%87

How I can get “HANDLING CHARGE EXPORT” together?

Anyone can help?

Thank you!

#2

Hi @joyozou
Use string array variable and say text.split(system.environment.newline(0))

Thanks
Ashwin.S

#3

@joyozou
String value = System.Text.RegularExpressions.Regex.Split(urVariableName,"\d").ToArray(0)

if ur variable contains “HANDLING CHARGE EXPORT 75.00 EUR 124.83 0”

u wil get output as “HANDLING CHARGE EXPORT” from above code

#4

Dear Manjuts,

It’s working. But it didn’t get the text I want it to be. It can only grab the second line of text.

%E5%9B%BE%E7%89%87
%E5%9B%BE%E7%89%87751×142 23.7 KB

%E5%9B%BE%E7%89%87

The text I want to extract is in the middle of txt file.

%E5%9B%BE%E7%89%87
%E5%9B%BE%E7%89%87757×546 51.9 KB

here is my workflow.

%E5%9B%BE%E7%89%87
%E5%9B%BE%E7%89%87999×602 17.7 KB

Could you have better advise?

thank you.

#5

Dear Ashwin,

I try your way, but it’s not working.

%E5%9B%BE%E7%89%87
%E5%9B%BE%E7%89%87966×426 20.5 KB

Do you have any other idea?

Thank you!

#6

@joyozou what output u getting in second write cell

#7

Hi @joyozou

Check the below post
How to split word in a line which contains comma as a separator give syntax

Thanks
Ashwin.s

#8

Dear Manjuts,

Here is the output to second write cell.

%E5%9B%BE%E7%89%87

thank you!

#9

A little difficult to me to understand how to split word in a line which contains comma as a separator.