Separate s.no

RPA Discussions
#1

how to separate the S.no from text in excel file???

Split number and text
#2

Can you please give the sample string here? @guptasweb

Or may be screenshot will work!

#3

output is
output is1335×658 334 KB

#4

So 1.1.1.1 are the serial numbers right? @guptasweb

#5

yes…correct

#6

I guess you are extracting this data from word doc right? @guptasweb

#7

hmmm…right

#8

So while dumping the data into excel you can remove those from word and then dump it @guptasweb

is this not possible?

#9

@guptasweb

Try to do this with automation and then paste it into excel sheet.

#10

word document
word document1893×823 335 KB

and its output should be like this
should
should1875×645 320 KB

1 Like
#11

Hey @guptasweb

You need to remove the S.No alone which is fine or you want the format as you posted above ?

Thanks
#nK

#12

i want the format which includes s.no and title

1 Like
#13

Hey @guptasweb

Cool. Is it possible for you to share the file here please ?

Thanks
#nK

#14

which file word,excel or xaml??

1 Like
#15

Word file with expected output excel file.

#16

AAM-5Ref-150-01-Equipment Sourcing.docx (109.1 KB)
0OutputSheet.xlsx (47.3 KB)

1 Like
#17

Thanks @guptasweb

Will check

#18

Hey @guptasweb

Here you go…

nmnithinkrishna_WordToExcel_19Apr2022_2234.zip (182.3 KB)

Kindly check and if you face any challenges please let us know.

Thanks
#nK

2 Likes
#19

hats of 2 u man…

1 Like
#20

Cool buddy :slightly_smiling_face::+1: