How to separate a value

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

								VIN: Jp00B-107201 - 999999
								ENGINE: Jp300Al022101 - 999999"

Please help me on this topic

Hi @Himanshu_Pratap_Rana ,

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.

Kind Regards,
Ashwin A.K

Output will be
Colour=00 (JET WHITE)
VIN=Jp00B-107201 - 999999
ENGINE=Jp300Al022101 - 999999

Colour is not present in get text

Hi @Himanshu_Pratap_Rana ,

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)

@Himanshu_Pratap_Rana ,

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 ?

Multiple value