How to print excel datatable value from a column with line break?

[bradt30h]

Hi Community,

I would like to print value ABC from the column with linebreak in Excel as per the image below. Understand that it can be done using %RPData[0][0]% to get "ABC". But, I would like to call out using Column name instead, to avoid error if col is moved. I tried with %RPData[0]['TEST1TEST2']% or %RPData[0]['TEST1 TEST2']% but fail.

Any ideas on how to call out columns with line breaks?

Appreciate it very much!

[MichaelAnnis · Accepted solution]

What if you replace text in the datatable and get rid of the column line break?

[VJR]

Hi @bradt30h ,

Here is a working way to do that..

• Read the Column Heading in a variable

        In this case the variable is MyColumnHeading.

        You can give a name similar to your Excel column headings.

        Also you can use a loop if you want to read all headings.

• Then use that column heading variable to get its value.

         Below is an example to display the 1st item (actually 2nd) from the data table.

         You can use the same inside a loop too. 

•         Here is the output after running the flow at line number 5.

• Below is how the overall flow looks like

[bradt30h]

Great one VJR,

But when reading, can it be dynamic? Now we are hardcoding the column cell. I am worried if the column is moved. So, I use Read from all available values from the worksheet.

[bradt30h · Accepted solution]

Hey VJR, I manage to do the alternative, I use "Find and Replace" function to replace the column name (with line break) with column (without line break). See the image below.

With this method, I can assure that even the column is moved, it will still work 🙂. Nevertheless, thanks so much for your help!

[bradt30h]

Hey Michael,

I didn't see your post earlier. Yes, replacing works! Thanks so much for your input 🙂

[VJR]

Okay @bradt30h , no worries 🙂. Since the original post said only about "how to call out columns with line breaks" therefore I didn't share any information considering you needed anything as flexible as moving columns.

1. Some recipients do not like replacing column headings. They need it as they are in the original file.

2. Using wild card as TEXT1* has the potential to replace any other column heading or also any other text in the entire file that matches this criteria (if All matches is selected).

3. If "only the first match" option is selected, this would not work if you want to skip the first match and replace only the second or the third.

For ex;

If you want to replace only the second column then using Name* wont work with the screenshot you have shared.

Again not sure how much flexibility you are looking for, but I'm sure you are okay with these above caveats and therefore you have gone ahead and implemented this approach.

Good to know you have found a solution to what you were looking for 👍.