Remove some text characters from each item of lists

1

Hello All
I am very new to Dynamo. I am trying to develop script for exporting gross area schedule to excel in a table format. ( The names of the area will be in column and levels in rows). I have got the lists extracted from the areas. I am facing two problems:

  1. How to get rid of some of the texts from the front and rear of each item.
  2. How do I align similar items in a column
    list
    list.png874×661 97.7 KB

    Thanks.
1 Like
2

@abhijeetraje Can you post your dyn? Can you show in Excel your desired result?

1 Like
3

you can do it in many ways
one of them is
image

and list.transpose for aligning them in column

1 Like
4

27-08-2018%201202
27-08-2018 1202.png989×360 8.63 KB

This is the result I want to have.It seems I am not allowed to post attachments yet.

5

Hey Thanks. Sorry for some basic questions. Will this work on list? or I will need to do something else before applying this?

6

it will work on list .

7

This should give you what you are after?

image
image.png1432×620 192 KB

image

8

OK… will try this… one question…will this work for

  1. Areas instead of rooms?
  2. When Multiple levels are there?
  3. If some of the rooms are not on all the levels, will the fields align in a column?
9
  1. I was just using rooms to extract some areas to get rid of the heading and suffix.
  2. Yes, it is all about organising your data before it get written to Excel.
  3. This is the same as the answer for question 2 it is all about organising your data.
10

This thread may help in organising your data…there are heaps of threads about this on the forum.

11

@Scott_Crichton
Thanks for the help. I think I can manipulate the data to get desired result.
Only one problem I have is how to fill the gaps in data. (if A-1 ,A-2 or some other names are not present on some floors, the list will be shorter, so unless the lengths are matched correctly, the entries in excel columns will be misaligned. )

Capture
Capture.png3680×1200 312 KB

12

Hey,

You’ve got a few options… Keep list structure, or Replace Empty (Clockwork or Orchid) should hopefully do the trick…

Cheers,

Mark

image

1 Like
13

Hi Mark

  Thanks for inputs. I am new to dynamo.Could you possible give some example how these nodes can be used to get the desired result?
14

HI. All
Since then I have searched for some more options in the forum. Based on this I have been able to reach to this point. Refer Attached .dyn , excel and screenshot. I just need help to get levels in the first row and only one header for the areas. Request some magic touch from you guyes. Thanks in advance.
04-09-2018%201420 Area Statement export to Excel-other aproach.dyn (51.9 KB)
new.xlsx (10.0 KB)

15

Hey,

Try this…

The structure of your list create wasn’t quite right, you had the name and area as a sub-list, I’ve just even’d it out…

With the ‘only one room name’… it could be that you haven’t deleted your excel file from a previous run… each export from dynamo only updates the cells you have told it too, so if you don’t delete the old excel you get historical data left over from previous runs…

Hope that helps,

Mark

Capture
Capture.png5650×864 307 KB

Area Statement export to Excel-other aproach-MKA.dyn (57.5 KB)

16

Hi.
Thanks for this. Unfortunately it is not working the way I want. Please find attached the screenshot of revit schedule and excel result I am attempting to have. Hope that clarifies the intent.new.xlsx (10.2 KB)
Revit%20Schedule

17

Hey, this is fairly close…

image

Capture
Capture.png6118×1398 406 KB

Area Statement export to Excel-other aproach-MKA-1.dyn (75.3 KB)
new.xlsx (8.5 KB)

I’d recommend BumbleBee package for more control over your output, there is a user guide to go with it.

18

Hey thanks. Actually this is giving output like normal export schedule.
What I was looking for was that name of the rooms should come in columns and levels on rows , that way it is more understandable table.
I will try out this Bumble bee package definitely.

19

Hey,

I made a graph which is the same as the image, but you’re saying you would like it differently?

Perhaps you could make an image of what you would like? Otherwise I have to guess and so far I have guessed wrong.

Thanks,

Mark

20

Actually I had attached excel sheet only… Attaching screenshot now.
desired%20result|655x113