Extract Text data to Excel


#1

Hello All,

I want to extract data from text to excel.

I want below data. I have attached my xaml. who can be kindly help me correct it would be much appreciated.Thank you!

Tax Invoice: 1500354862
Total Net Amount Taxable: SGD 879.27
Total Tax Amount: SGD 7.00
Total Invoice / Credit Amount: SG D 886.27

texttoexcel.zip (475.4 KB)


#2

You fould use the Substring function to add the type into one string, and value into a different string. Then input the data.

Check also out “Write Cell” function for writing to Excel


#3

Thank you Smith!Sorry I am not quite understand. Could you explain more?