How to convert once cell data in multiple cells

[kishore_praveen (kishore stunning)]

[ABCD 13-9 | 20203107SUGAR:2789234]
[ABCD 13-4 | 20202101SUGAR:5345464]

–scarped from web into excel

want to convert into this

ABCD	dt	tint	date	Product
2789234	13	9	10-11-2020	Sugar
5345464	13	4	11-22-2020	Tea

[ppr (Peter Preuss)]

testline and table are not fully matching or data is not present. in general we can try get it parsed with regex and refering to groups. We also can extract parts of the line and reprocess more in detail

[THIRU_NANI (NaNi)]

Hi! welcome to community!

You can use String manipulation to achieve your requirement.

ex:-

Sample:

text.Split(" ".ToArray)(0).Replace("[","").ToString

Reference:-

How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Hi, if you are a beginner in the world of automation and would like to know how you can manipulate text based on the solutions available in the VB.NET code and using REGEX (regular expressions) then you are in the right place. In the topic below, you will learn how to easily extract data from any part of the search text using various methods. The topic includes solution examples with descriptions and graphics to better understand the topic for functions such as: Split Substring Left Right R…

Regards,
NaNi

[kishore_praveen (kishore stunning)]

i have edited the question again …it should match now

[ppr (Peter Preuss)]

unsure about the date, but in general the same approach

• read in text
• split on lines
• extract e.g. with regex
• Add it to a prepared datatable | OR feed in to a generate table avctivity
• get back a datatable and write it out to excel