I have a value in variable and separate a value in Colour=00(Jet white),Vin=S300B-103201 - 999999,
ENGINE=E022101 - 999999 and add in data row.
Example-Value in variable
00 (JET WHITE)
VIN: Jp00B-107201 - 999999
ENGINE: Jp300Al022101 - 999999"
Please help me on this topic
I’m sorry but your query is unclear, could you please elaborate on the requirement once more?
How do you want the text to be split and fed into a DataTable?
An example of the output would be most appreciated.
Output will be
Colour=00 (JET WHITE)
VIN=Jp00B-107201 - 999999
ENGINE=Jp300Al022101 - 999999
Colour is not present in get text
Maybe we are still lacking in Information, and Hence, we are not able to provide a Strong Solution.
Could you provide us full Input data in a Text file ? Maybe Some more Samples too?
Or Rather would you confirm if there are always 4 Lines of Data as your Input ?
Can u give us a sample input value and sample output required out of it
Book1.xlsx (8.7 KB)
The Input is still not clear.
From the Image, we can see that there are two
VIN: Keywords, If they are two, then which one to be used in the Output Excel ?