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 …

Extract data from txt

AshwinS2 (Ashwin S) June 8, 2018, 6:08am 7

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 studio	1	1109	October 21, 2018
How to extract data and write in to seperate cells Studio studio , question , activities_panel	6	646	September 2, 2022
Text to Excel data Extraction Help	5	1079	April 26, 2019
Extracting Particular Data from a .txt file Help activities , question , data_manipulation	6	1468	November 11, 2019
String Manipulations to get the particular line from the datatable's cell Studio studio , question , activities_panel	12	894	October 21, 2022