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 activit…

@Anbumani Welcome to the forum [image] 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: [grafik] write range

[image] 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.

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 …

@Anbumani Check here, [image] Xaml File Main.xaml (7.8 KB)

@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.

[image] 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 [image] Anbumani: but it won’t help for us. we dont know what w…

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!! [image] Here is the GenerateDataTable activity sc…

@kumar.varun2 Thanks a lot!! Appreciated!! It’s work as expected!!

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

Help Studio

kumar.varun2 (Varun Kumar) April 27, 2023, 7:46am 9

Hi @Anbumani

Try this approach

StoreStrinValueAsColumns.xaml (8.0 KB)

1 Like

Forum Engagement Daily Reports

Topic		Replies	Views
Save values in a string to different columns of a data table Help datatable , studio	13	8060	September 13, 2017
How to get data from text file to Excel file StudioX excel , uiautomation , activities , studiox , question	10	1206	February 8, 2023
How to get data from a text file and put it in a column A1,A2,A3,...,An Activities datatable , excel , studio , question , activities_panel	3	552	July 13, 2023
Generate DataTable - Specific data is not stored in correct column Help activities , question	6	1047	December 17, 2019
Splitted text write to excel Studio studio , question , activities_panel	7	1258	August 9, 2022

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

Related topics