20
Views
6
Comments
Remove space in Header Name in excel
Question

Hi,

Need to remove space in header name in excel so that I can match that header name in entity and add that from excel to entity

2024-03-22 09-17-23
Chandra Vikas Sharma

Hi Vivek,

if you are using structure for creating excel so  structure attribute you can change the label for what you need to show in the header of the excel file.


Thanks

CV


UserImage.jpg
Vivek Pandurang Pandile

I am importing excel data and need to insert data in entity.

2024-03-22 09-17-23
Chandra Vikas Sharma

Hi Vivek,

you can try with below forge component.

https://www.outsystems.com/forge/component-overview/355/advanced-excel-o11

Thanks

CV

 

UserImage.jpg
Vivek Pandurang Pandile

can you please tell me which function need to use to achieve this.

2024-10-03 06-54-46
PRAVEEN RAJKUMAR

@Vivek Pandurang Pandile advanced-excel-o11 don't has any component to remove space you can go with trim to remove space.

2024-10-03 06-54-46
PRAVEEN RAJKUMAR

@Vivek Pandurang Pandile if you need to remove space in header name just use trim to restrict the space in getting header value.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.