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 …

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

@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

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%87] The text I want to extract is in the middle of txt file. [%E5%9B%BE%E7%89%87] here is my workflow. [%E5%9B%BE%E7%89%87] Could you hav…

Dear Ashwin, I try your way, but it’s not working. [%E5%9B%BE%E7%89%87] Do you have any other idea? Thank you!

@joyozou what output u getting in second write cell

Hi @joyozou Check the below post How to split word in a line which contains comma as a separator give syntax [image] How to split word in a line which contains comma as a separator give syntax Help I need a answer for split word in a line which contains comma as a separ…

Dear Manjuts, Here is the output to second write cell. [%E5%9B%BE%E7%89%87] thank you!

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

Extract data from txt

Help

AshwinS2 (Ashwin S) June 8, 2018, 6:08am 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

Topic		Replies	Views
Array txt to excel Help excel , activities , studio	1	1139	October 21, 2018
String Manipulations to get the particular line from the datatable's cell Studio activities , studio , question , system , activities-panel	11	1052	October 21, 2022
Convert text into excel file Studio excel , activities , studio , question , tools	2	805	June 29, 2021
Read and split data from excel Studio excel , activities , studio	13	503	July 13, 2023
How to extract data and write in to seperate cells Studio activities , studio , question , system , activities-panel	5	789	September 2, 2022

Extract data from txt

Related topics