How to store the string value like as column wise in excel

[Anbumani]

Hi Team,

Thanks in Advance!!

Here the scenario, We have one text file with the number of line items. In the each line item we have to separate the value using tab and need to stored the value in excel. Please refer the below scenario’s and expected output.

Note: We tried GenerateDatatable activity it won’t help for us. It’s broken the value.

Line items will be like:-

Expected Output:-

Thanks & Regards,
Anbumani S

[ppr (Peter Preuss)]

@Anbumani
Welcome to the forum

@Anbumani

In the each line item we have to separate the value using tab and need to stored the value in excel.

Give a first try at:

• read CSV
  set tab as delimiter:
  

• write range

[supermanPunch (Arpan)]

@Anbumani

Note: We tried GenerateDatatable activity it won’t help for us. It’s broken the value.

Hi @Anbumani ,

Do try with the method suggested by @ppr , If possible also let us know what was the configuration done on the Generate Datatable activity.

[Vishnuraj_Pandiyarajan2 (Vishnuraj Pandiyarajan)]

hi @Anbumani

you can use this expression
Step 1: first need to split text based on Tab function and store it in list

var_List=yourtext.Split(vbTab.ToCharArray())

Step 2: creat build data table with headers
Step 3 : take For each activity and and mention you list
Step 4: inside the For each loop use Add data row activity and insert your data with it.

let me know if the procedure helps

Thanks you
VP

[Manju_Reddy_Kanughula]

@Anbumani

Check here,

Xaml File

Main.xaml (7.8 KB)

[Anbumani]

@ppr @supermanPunch we already tired this logic but it won’t help for us.
@Vishnuraj_Pandiyarajan2 We need to store the value like as column wise not in row wise.

[ppr (Peter Preuss)]

@Anbumani

we already tired this logic

we used this logic, options in combination with generate datatable and also custom parsing approaches. We got it working and selected approaches depending on project specifics

@Anbumani

but it won’t help for us.

we dont know what was done, so we cannot process this feedback for further suggestions

Feel free to share with us a sample data text file

[Anbumani]

Sorry for delay response!!
Here I have attached my sample input and expected output.
Please review the scenario and help me for proceed further.
TestText.txt (139 Bytes)

For excel not able to upload here so please refer the below screen shot!!

Here is the GenerateDataTable activity screen shot for your reference!!

[kumar.varun2 (Varun Kumar)]

Hi @Anbumani

Try this approach

StoreStrinValueAsColumns.xaml (8.0 KB)

[Anbumani]

@kumar.varun2 Thanks a lot!! Appreciated!!

It’s work as expected!!