ExtractEach Row into its own variable

Help Studio
, ,
1

I have a text file that I would like to split each row into its own variable. The number of rows is always 6

03/23/2023 11:37:25
03/23/2023 11:38:25
03/23/2023 11:39:25
03/23/2023 11:40:25
03/23/2023 11:41:25
03/23/2023 11:42:25

2

@tomaz

You can use split activity

read the data into string str

str.Split({Environment.NewLine},StringSplitOptions.None) this will give you an array of all the rows

cheers

3

we would not recommend to have separate variables as with an array and an index we can access discrete

Assign Acitvity
arrLines | String Array = File.ReadLines("YourFullFilePathToTheTextFile")

first line = arrLines(0)
second = arrLines(1)
…

4

Hi @tomaz ,

You can convert your string to an array of strings with respect to new line using the below expression:

StringVariable.Split(Environment.Newline.ToCharArray)