https://community.qlik.com/t5/App-Development/field-name-with-space-char/m-p/2482942#M100963 <P>hi!</P> <P>i need to store a table in .CSV, but some of the fields must start with space char ' '.</P> <P>in the example i will need to replace all '#' with ' ', and store the table in csv format.</P> <P>every time that i do that - QS remove the blanks automatically.</P> <P>[export]:<BR />LOAD * INLINE <BR />[<BR />#HEADER_1|#HEADER_2|HEADER_3|HEADER_4<BR />#Field_1|Field_2|Field_3|Field_4<BR />] (DELIMITER IS '|');</P> <P>&nbsp;</P> Mon, 23 Sep 2024 06:50:55 GMT eladberko 2024-09-23T06:50:55Z https://community.qlik.com/t5/App-Development/field-name-with-space-char/m-p/2482942#M100963 <P>hi!</P> <P>i need to store a table in .CSV, but some of the fields must start with space char ' '.</P> <P>in the example i will need to replace all '#' with ' ', and store the table in csv format.</P> <P>every time that i do that - QS remove the blanks automatically.</P> <P>[export]:<BR />LOAD * INLINE <BR />[<BR />#HEADER_1|#HEADER_2|HEADER_3|HEADER_4<BR />#Field_1|Field_2|Field_3|Field_4<BR />] (DELIMITER IS '|');</P> <P>&nbsp;</P> Mon, 23 Sep 2024 06:50:55 GMT https://community.qlik.com/t5/App-Development/field-name-with-space-char/m-p/2482942#M100963 eladberko 2024-09-23T06:50:55Z https://community.qlik.com/t5/App-Development/field-name-with-space-char/m-p/2482963#M100966 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/213849">@eladberko</a>&nbsp; try below</P> <LI-CODE lang="javascript">rename_fields: mapping Load FieldFrom, Replace('['&amp;FieldFrom&amp;']','#',chr(160)) as FieldTo; Load * Inline [ FieldFrom #HEADER_1 #HEADER_2 #HEADER_3 ]; [export]: LOAD * INLINE [ #HEADER_1|#HEADER_2|#HEADER_3 ] (DELIMITER IS '|'); Rename Fields using rename_fields;</LI-CODE> Mon, 23 Sep 2024 08:38:34 GMT https://community.qlik.com/t5/App-Development/field-name-with-space-char/m-p/2482963#M100966 Kushal_Chawda 2024-09-23T08:38:34Z