Disposition of a string in a file horizontally


#1

Hi,
I have a problem with the disposition of a string in an Excel sheet.
I attach a picture of how I extract a string from a txt file into an Excel Sheet
The string in the txt file is:
Sinistri resp. principale

0

0

0

0

00

00


Is there a possibility to save the string horizontally in the Excel sheet?
Or maybe is there a possibility to extract the text from the txt file so that it is in an horizontal disposition, not in a vertical one?
Thank you,
Camilla.


#2

@camicaT, Lets say you have stored the value from excel into a string variable (strVerticalValue) that contains

ASSIGN
strHorizontalValue = String.Join(" ",strVerticalValue.Split({Environment.NewLine},StringSplitOptions.RemoveEmptyEntries))

Note: Kindly refer our forum posts before you ask that gives you more than what you expect :slight_smile:

Regards,
Dom :slight_smile:


#3

Thank you so much @Dominic.
It solved my problem.
Regards,
Camilla.