I’m relatively new to UiPath and although i’ve had success in creating a few scripts, but they are largely similar in terms of function i.e. read excel, copy selected data from it, paste them into another excel file and make use of these data to run some processes.
However, i’m trying something new and that is to work on the actual excel file itself but i have no idea how do i go about doing it. Am i able to only work on the file by reading the excel file as a datatable then output it again?. Example: https://imgur.com/a/AhQyFic
I’m tidying up the data within this excel as a lot of them are old and contain irrelevant information. So here are the steps that i’d like to perform:
- Only extract out the 1st 3 tokens in the name, or any name tokens before the first special characterlike brackets, @, S/O etc
Example 1: ABCD EFGH IJKL S/O MNOP QRST @ UVWX YZ, i’d only need ABCD EFGH IJKL
Example 2: ABCD D/O MNOP QRST @ UVWX YZ, i’d only need ABCD
The data that’s cleaned up should be placed in column ‘E’.
Next, i’ll need to sieve out rows that has a positive NET_LIABILITY_AMT (by using the number filters function in Excel, we’ll normally use “Greater than” selection)
Lastly, to filter away Phone numbers that contains no value (Excel function: Filter)
My apologies for not being able to upload the excel file. I’m a new user so the forums doesn’t allow me to upload files.
Once again, thanks to all in advance. Please feel free to let me know if there’s any other information that I can provide.
Thank you, appreciate it.