Split text from the image

Help
1

Trim%20notepad

Hello,
How to show image text into separate output using : (colon) as a separator
as attached image above i want Name and ABC as a separate output.
I converted that image into text but i want that separate output as above mentioned.
Thanks in advance

2

@abhay Read the text file, split with respect to new line, then u will get each line separately, split each line with respect to “:” then u will get Name and ABC separately likewise it repeat for all lines.

3

@Manjuts90 how can i split with respect to new line?

4

@abhay

urStringvarible.Split({Environment.Newline},StringSplitOptions.RemoveEmptySpaces)

where usStringvariable is a string variable, which is the output of read text file activity.

Or

in other way u can store lines in array from text file using directly.

File.ReadAllLines(“ur file path”)
it will give array of lines as output.

5

@abhay check attached zip file meets your requriement

SplitTxt.zip (1.9 KB)

1 Like
6

@Manjuts90 this give me error

error
error889×222 12.9 KB

7

@abhay

it is not spaces, it is entries. After dot u will get that option check it once.

urStringvarible.Split({Environment.Newline},StringSplitOptions.RemoveEmptyEntries)

1 Like
8

thanks @Manjuts90 got it…:+1:
RemoveEmptyEntries work instead of RemoveEmptySpace

1 Like
9

@Manjuts90 @indra Now i want to write csv in that csv column name should be Name Add Phn and Gender and their data should be ABC PQR 123 Male

10

thank you @indra

11

@abhay After splitting each line with respect to “:” add arr(0) as column name and arr(1) to collection at the end of for u can use add data row activity for writing row to datatatable and later u can write datatable to csv or excel.

1 Like
12

thank you @Manjuts90 its work perfectly now

1 Like