Murali

Help Studio
1

Hi I want to read 12 digit account number from CSV file and I should write in excel file how can I do this

2

Please share the sample CSV here

3

HI @murali_potnuri

You can try with Text to column activity in Modern design

image
image655×849 28.3 KB

If you dont find these activities you can enable the modern design
Go To Activities Panel → Filter → Show Modern or Modern in your list
image

Regards
Sudharsan

4

After this you have a column with account no and you can use it

another way you can use Read CSV Activity to read the data and store them in the datatable

In the properties of CSV you select the delimeter and it will be automatically seperated and you will get the account number in the seperate column

Dt.DefaultView.ToTable(False,“Account No”) will get you only the data of the account number

you can use this expresion and write them in the excel

Regards
Sudharsan